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?
Instructions for dumping a MySQL database can be found here... http://dev.mysql.com/doc/mysql/en/mysqldump.html on the MySQL website. Cheers.
If you don't have a database password (very insecure!), use this: Code: 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: Code: 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
