SQL dumps

[woody]

I know I can do this by using phpMyAdmin, but I wonder if/how I can create sql dumps of my MySQL databases on the commandline?

[sphere]

Instructions for dumping a MySQL database can be found here...

http://dev.mysql.com/doc/mysql/en/mysqldump.html

on the MySQL website.

Cheers.

[ingo]

If you don't have a database password (very insecure!), use this:

mysqldump -h <db_server, e.g. localhost> -u <db_user, e.g. root> -c --add-drop-table --add-locks --all --quick --lock-tables <db_name> > /path/to/your/sql_dump.sql

If you have a database password:

mysqldump -h <db_server, e.g. localhost> -u <db_user, e.g. root> -p<db_password, no space after -p!> -c --add-drop-table --add-locks --all --quick --lock-tables <db_name> > /path/to/your/sql_dump.sql

Ingo