There was a problem loading the comments.

How to backup and restore MySQL database

Support Portal  »  Knowledgebase  »  Viewing Article

  Print

If you run a database driven website, it is important to backup your databases, periodically. You can generate a full backup to do this, but you may decide it is unnecessary to backup everything. So, here is how to backup just your databases.

To backup the databases,do the following:

1. Login to the cPanel and click on Backups link in Files section.

2. Under Download a MySQL Database Backup, click the name of the database.

3. A Pop-up window will appear wherein click Save As or Save File and select a destination for where you would like the back up to be locally saved.

4. Click Save.

Once you have a backup, if you ever inadvertently lose your data, then you can restore the database easily and quickly.

To restore the database,please do the following:

1. Login to the cPanel and click on Backups link in Files section.

2. Click the Browse button beneath the option which says Restore a MySQL Database.

3. Select the .sql.gz file which you want to be restored.

4. Click on Open and then click the Upload button.

Database will be restored successfully.


Share via

Related Articles


Self-Hosted Help Desk Software by SupportPal
© Balasai Net Pvt Ltd