How to Backup/Restore Your MySQL Database
- Full Backup
- Home Directory Backup
- MySQL Database Backup
If you run a database driven website, it is important to backup your databases on a periodic basis. While databases are included in a full backup, you may wish to only backup an individual database.
Backup a Database
To backup a database:
- Log into cPanel.
- In the Files section, click on the Backups icon.
- Under Download a MySQL Database Backup, click the name of the database you want to backup.
- In the pop-up that appears, select the Save File option and select a destination on your local machine where you would like the backup stored.
Once the backup is saved, you can quickly and easily restore the database if you should ever lose your data.
Restore a Database
To restore a database:- Log into cPanel.
- In the Files section, click on the Backups icon.
- Under Restore a MySQL Database, click Browse.
- Select the .sql.gz file which you want restored.
- Click Open.
- Click Upload.
Your database will then be uploaded and the database driven website should begin working shortly.
