MySql extract

[tamasu]

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]

Post by tamasu
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

mysqldump --all-databases >backup.sql

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