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