Automatic MySQL database backup

The JetBackup tool will automatically back up your MySQL databases once a day and will save 7-days of backups to restore. With automated and daily database snapshots of your website, you'll be able to easily access a MySQL backup should you need one to restore your database. Learn more about how to download and restore your website using JetBackup in this Help Article. 

Important: It is not recommended to restore a JetBackup MySQL database using the cPanel Backup restore process. The restore process for both types of backups is not identical.  

Manual MySQL database backup

With cPanel Backups you have the option to manually download a full website backup or just download a MySQL backup, referred to as a partial backup. A full backup includes the MySQL database and all of your website's files and configuration. You can restore a MySQL backup in cPanel but not a full backup. Full and partial backups can be stored in the home directory, downloaded to your local drive, or transferred and stored elsewhere using FTP. 

Jump to:

• Create a MySQL database backup
• Restore your database from a backup

Create a MySQL database backup

1. Sign in to your My Services page.
2. Click the Web Hosting link.
   
3. Click the Backup link in the Files module.
4. In the Partial Backup section, click the Link under Databases in the Download a MySQL Database Backup section. Note: A .sql file will download to your local drive. 

Restore your database from a backup

1. Sign in to your My Services page.
2. Click the Web Hosting link.
3. Click the Backup link in the Files module.
4. In the Partial Backups section, click the Browse button under Restore a MySQL Database Backup. A modal will open to find the MySQL file on your local drive.
5. Click the Open button to load the MySQL file.
6. Click the Upload button to restore the MySQL file.
7. A confirmation message will appear if the MySQL file was successfully restored. 

  See Also:

• How do I back up my database?
• How do I use the MySQL Dump tool?
• Export database and tables in phpMyAdmin
• Backup your website using the WordPress Toolkit