PDA

View Full Version : SQL dumps


woody
3rd May 2005, 12:40
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
3rd May 2005, 16:41
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
4th May 2005, 11:57
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