Download and Restore MySQL Database Backup

Backups are a very important part of maintaining a website. It is important to back up your files and databases on a week-to-week or month-to-month basis, or before making any major changes, so that a backup is available in the event of data loss.

• Create a MySQL Database Backup ⤵
• Restore a Home Directory Backup ⤵

A MySQL database backup will back up all data in a specific database. This can be useful for backing up the valuable data of various scripts; however, it is only a partial backup. It will not include DNS, home directory files, or other system files and settings. If you would prefer to generate a full backup, please see the following article:

• How to Generate/Download a Full Backup

Create a MySQL Database Backup

To create a backup of your MySQL Database:

1. Log in to cPanel.
2. In the Files section, click on the Backups icon.

   
    

3. Under Partial Backups, look for Download a MySQL Database Backup, and then click the name of the specific database you want to back up.

   
    

4. Wait for the download to complete.

The backup file will be downloaded as a .sql.gz file, which can be opened with the Linux command line. The file can also be unzipped from a Windows-based machine with the appropriate software.

Restore a Home Directory Backup

A MySQL database backup can be restored in cPanel in the same place where the backup was created.

1. Log in to cPanel.
2. In the Files section, click on the Backups icon.

   

3. Under Partial Backups, look for Restore a MySQL Database Backup, then click the Browse button.

   
    

4. Navigate to the appropriate destination in the pop-up that appears and select the backup file you intend to use.
5. Click Open.

   
    

6. Click Upload.

   
    

7. A pop-up will appear, displaying the database name and status of the database restore. This is only for confirmation purposes and is safe to close.