How to Download and Restore a MySQL Database Backup?

Create a MySQL Database Backup
To create a backup of your MySQL Database:
1. Log into cPanel.
2. In the Files section, click on the Backups icon.
3. Under Partial Backups > Download a MySQL Database Backup, click the name of the specific database you want to backup.
4. In the popup that appears, click Save As or select Save File.
5. Select a destination where you would like to store the backup locally.
6. Click Save.

The backup file will be downloaded to the destination you have chosen in a .sql.gz file which can be opened with Linux command line. The file can also be unzipped from a Windows-based machine with the appropriate software.

A MySQL database backup can be restored in cPanel, in the same place where the backup was created.
1. Log into cPanel.
2. In the Files section, click on the Backups icon.
3. Under Partial Backups > Restore a MySQL Database Backup, click on the Browsebutton.
4. In the popup that appears, navigate to the appropriate destination and select the backup file you intend to use.
5. Click Open.
6. Click Upload.

Was this answer helpful?

 Print this Article

Also Read

How to restore a backup using Plesk?

1. Log into Plesk2. Click on Domains3. Click on Manage Domain or Manage Hosting4. Click on...

How to take a backup using Plesk Panel?

CREATING AN INSTANT BACKUPWith an instant backup, you can create an immediate backup of your...

1)How to backup your data using Cpanel?

A "Backup/Restore" feature is included in cPanel/Plesk with each hosting plan and you can use...

How to Download a Home Directory Backup?

In order to create a backup of your home directory, You need to follow the below mentioned...