MySQL Dump/Restore

MySQL Dump/Restore

Dump ALL MySQL Databases
mysqldump –user=user_name –password=password -A > /PATH/TO/DUMPFILE.SQL

Dump Individual or Multiple MySQL Databases
mysqldump –user=user_name –password=password –databases DB_NAME1 DB_NAME2 DB_NAME3 > /PATH/TO/DUMPFILE.SQL

Dump only certain tables from a MySQL Database
mysqldump –user=user_name –password=password –databases DB_NAME –tables TABLE_NAME > /PATH/TO/DUMPFILE.SQL

To make dumps compatible with older versions add the following switch:
–compatible=mysqlXXX

Use the following to reload the contents of a database:

mysql –verbose –user=user_name –password=password DB_NAME < /PATH/TO/DUMPFILE.SQL