Command Center

Dump ALL MySQL Databases

mysqldump --user=XXXXXXXX --password=XXXXXXX -A > /PATH/TO/DUMPFILE.SQL<br />



Dump Individual or Multiple MySQL Databases

mysqldump --user=XXXXXXXX --password=XXXXXXX --databases DB_NAME1 DB_NAME2 DB_NAME3 > /PATH/TO/DUMPFILE.SQL<br />



Dump only certain tables from a MySQL Database

mysqldump --user=XXXXXXXX --password=XXXXXXXX --databases DB_NAME --tables TABLE_NAME > /PATH/TO/DUMPFILE.SQL<br />



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:

1. Unzip the backup file you wish to use.
   
2. Open it up and pull out only the information that you will need.
   
3. Save this text file.
   
4. 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<br />



REFERENCES
http://www.patrickpatoray.com/index.php?Page=30