1. Home
  2. Hosting Management
  3. Backups & Restores
  4. How to Download and Restore a MySQL Database Backup

How to Download and Restore a MySQL Database Backup

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.

mysql backup cpanel

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.

cpanel mysql backup

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“.

 

cpanel restore mysql backup

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“.

restore mysql backup cpanel

5) A new tab will open showing you information about the restore process.

restore mysql backup

Updated on March 26, 2020

Was this article helpful?

Related Articles

TRY CHEMICLOUD RISK-FREE
Fast, secure cloud hosting. 18 global data centers. Unhappy with your web host?
👉 Migrate for Free

Leave a Comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.