Dump Restore
MySQL Dump/Restore
Taken from here: http://www.patrickpatoray.com/?Page=30
Dump ALL MySQL Databases:
mysqldump --user=XXXXXXXX --password=XXXXXXX -A > /PATH/TO/DUMPFILE.SQL
Dump Individual or Multiple MySQL Databases:
mysqldump --user=XXXXXXXX --password=XXXXXXX --databases DB_NAME1 DB_NAME2 DB_NAME3 > /PATH/TO/DUMPFILE.SQL
Dump only certain tables from a MySQL Database:
mysqldump --user=XXXXXXXX --password=XXXXXXXX --databases DB_NAME --tables TABLE_NAME > /PATH/TO/DUMPFILE.SQL
I'm using MySQL 4.1.8 on my development server, but am behind a few releases on our production server. In order to make dumps compatible with the old MySQL version, add the following switch:
--compatible=mysql323
Use the following procedure to reload the contents of a database:
- Unzip the backup file you wish to use.
- Open it up and pull out only the information that you will need.
- Save this text file.
- Use the following command to feed back in the contents of a text file:
mysql --verbose --user=XXXXXXXX --password=XXXXXXXX DB_NAME < /PATH/TO/DUMPFILE.SQL
Some more Options:
http://www.thegeekstuff.com/2008/09/backup-and-restore-mysql-database-using-mysqldump/
http://www.webcheatsheet.com/SQL/mysql_backup_restore.php
Google Search: --> http://www.google.com/search?q=mysql+dump+restore