|
How to backup / restore your MySQL Database
If you run a database driven website, it is important to backup your databases very frequently. You can generate a full back up to do this as well but sometimes it may not be unnecessary to backup everything, just to backup your databases. To just backup the databases please do the following:
- Click Backups
- Under Download a MySQL Database Backup click the name of the database for which you wish you would like to back up.
- Click save as.
- Select a destination, where you would like the backup to be locally saved to.
If you have ever made a boo-boo with a database, you can always restore the database very easily and quickly. To restore a database, please do the following:
- Click Backups
- Click the Browse button next to the option which says "Restore a MySQL Database"
- Select the SQL file for which you would like to be restored.
- Click the open button and click the upload button.
This will now upload the MySQL file which you can see in the “MySQL Databases” section in cPanel. You can also make changes to it in PHPMyAdmin.
|
