» restore

MySQL Dump/Restore 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 DB_NAME1 DB_NAME2 DB_NAME3 > /PATH/TO/DUMPFILE.SQL Dump only certain tables from a MySQL Database : mysqldump –user=XXXXXXXX –password=XXXXXXXX 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 t...

You can backup your database using PHPMyAdmin in just a few mouse clicks. First head over to your database by clicking the database name in the list on the left of the screen. Once you get to your database details, you should get a menu header for your database which looks like so: Click on Export. This will get you to a screen with the following options. From here it’s just a matter of clicking the right options and the ‘Go’ Button to get your database dump. To save the backup file on your computer, click on the Save as file option and the corresponding compression option ...