It is very important that you always keep several backups of you critical data. If you need to back up your MySQL database in cPanel, here is how you can accomplish that:How to backup your mySQL database in cPanel
How to Restore a mySQL Database in cPanel
If you have a backup of a MySQL database saved as an uncompressed .sql file or a compressed .sql.gz, .tar.gz or .tgz file, you can restore that database to your cPanel account fairly easily. Here's how to do it:
- Log in to your cPanel: https://YOURDOMAIN.com/cpanel
- Click on “Backup” under the section Files.
- Under “Restore a MySQL Database Backup”, click on the “Choose File” button.
- Select your sql, sql.gz, .tar.gz or .tgz file to restore.
- Click “Upload” and be patient. Larger backups may take some time to finish restoring.