Please let us know how this article can be improved.
Choose all that apply.*
Report a bad link
Out of date (instructions or screenshots)
Missing detail
Other
How do I use the MySQL database backup/restore tool?
Learn how to revert your MySQL database to a previous version.
Jun 20, 2024
Article ID: SLN20623
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.
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.
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.
Click the Open button to load the MySQL file.
Click the Upload button to restore the MySQL file.
A confirmation message will appear if the MySQL file was successfully restored.
