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
Related Articles
How to Download a Home Directory Backup?
In order to create a backup of your home directory, You need to follow the below mentioned...
How to backup your data using cPanel?
A "Backup/Restore" feature is included in cPanel/Plesk with each hosting plan and you can use...
What is your backup Policy?
We Provide Daily and weekly backups for all accounts whose size is below or up to 1GB.However...
How often do you do backups?
We provide backups on daily and weekly basis.
My account is Suspended; I need the backup of my account.
If your account is suspended you can not take backup of your account;since to take backup ,...
