How to Backup and Restore a mySQL Database in cPanel

How to backup your mySQL database in cPanel

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:

  1. Log in to your cPanel:  https://YOURDOMAIN.COM/cpanel

  2. Click on “Backup” under the Files section:
     

  3. Under the section “Download a MySQL Database Backup”, click on the database you would like to backup:


  4. The database will now be saved to your local machine where ever your downloaded files are saved to.


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:

  1. Log in to your cPanel: https://YOURDOMAIN.com/cpanel

  2. Click on “Backup” under the section Files.
     

  3. Under “Restore a MySQL Database Backup”, click on the “Choose File” button.
     

  4. Select your sql, sql.gz, .tar.gz or .tgz file to restore.

  5. Click “Upload” and be patient. Larger backups may take some time to finish restoring.


Was this article helpful?

mood_bad Dislike 0
mood Like 0
visibility Views: 164