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.
- 0 Users Found This Useful
