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.
