Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

MySql extract

0 views
Skip to first unread message

tamasu

unread,
Dec 7, 2009, 4:13:59 PM12/7/09
to
Hi,

I have a mysql database populated with data that I need to transfer to
another system. Could you kindly guide me how can I extract all schema
+ data into a single SQL file (including the INSERT commands) or
should I just copy the database file?

Can you guide me?

Thanks

Luuk

unread,
Dec 7, 2009, 5:18:19 PM12/7/09
to
tamasu schreef:


mysqldump --all-databases >backup.sql

see: http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

--
Luuk

0 new messages