How to download a MySQL Database Backup
The cPanel backup interface allows you to generate and download a backup of your MySQL databases. Backing up your website’s database periodically is always recommended, as it can save you from a lot of pain in case anything happens with your data. It is often necessary to take a backup (or “dump”) of an entire database management system along with all databases and tables, including the system databases which hold the users, permissions, and passwords.
1) Log into cPanel.
2) Look for the “Files” section and click on the “Backup” icon.
3) In the “Partial Backup” section under “Download a MySQL Database Backup “ click on your database name you want to backup, in this case, it’s chemiclo_demo and the download will start automatically.
A copy of the database will now to saved on your PC, and you should now see the compressed .sql.gz file in the folder your web-browser downloaded it.
How to restore a MySQL Database Backup
If your database is corrupted or you have removed some useful data, restoring the database from a previous working backup might be a great option to save the day. Luckily this can easily be done by following the next steps:
1) Log into cPanel.
2) Look for the “Files” section and click on the “Backup” icon.
3) In the “Partial Backup” section click the “Choose File” button located under “Restore a MySQL Database Backup “ and select the backup file you want to use from your PC and click “Open“.
4) Now the name of the backup file you selected should be displayed, please double check that this is the right backup and click “Upload“.
5) A new tab will open showing you information about the restore process.
