Data base backup

Mysql Database Backup

Rule 1 You should always backup your database

Rule 2 You should backup your database regularly, and always before an upgrade

Rule 3 If you don't backup your database, eventually something will happen, you will lose all your data and you will wish you had backed up your database


Now for the good news, If you use Database Backup Generator, you can sit back safe in the knowledge that your database is being backed up, and its child's play to restore a corrupt database.

More information on the hard way to backup your mysql database

Article Index
Backing up and Restoring your MySQL Database  
2. What about Multiple Databases  
3. Easy Restore  
4. PHPMy Admin  
5. Backing up and Restoring your databse with PHPMy Admin  
6. Home  

(Page 5 of 5 )
Backing Up and Restoring Your MySQL Database - Backing Up and Restoring Your Database with PHPMyAdmin

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:

But I would highly recommend the fully automatic database backup system availabe at

Back up with PHPMyAdmin

Click on Export . This will get you to a screen with the following options.

Backup with PHPMyAdmin

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 to get the backup to download to your system.

Restoring your Database via PHPMyAdmin

Restoring your database is as easy as backing it up. If you would like to rewrite the backup over an existing database, click on the database name in the database list on the left, click all the check boxes next to the table names and select Drop in the With selected : drop down box.

Restore with PHPMyAdmin

This will drop all existing table in the database. Then head over to the top menu bar and click on SQL . This will bring up a window where you can either type in SQL commands, or upload your SQL file. The window should look like this:

Restore with PHPMyAdmin

Click on the Browse button, and select the sql backup file you wish to upload to the server . Once you've selected the file, click on 'Go'. This will upload the backup file to the server and execute the SQL commands in the backup and restore your database.

Now that you know how easy it is to backup and restore your database, spend a few minutes everyday to backup your important data. You can even automate the backup process by using a task scheduler like cron.