MySQL Dump/Restore


Dump ALL MySQL Databases


Dump Individual or Multiple MySQL Databases


Dump only certain tables from a MySQL Database


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:
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: