How to backup/restore your MySQL database Print

  • 1

If you run a database driven website, it is important to backup your databases very frequently. You can generate a full back up to do this as well but sometimes it may not be unnecessary to backup everything, just to backup your databases.

To backup the databases please do the following:
1. Click Backups.
2. Under Download a MySQL Database Backup, click the name of the database.
3. Click Save As.
4. Select a destination for where you would like the back up to be locally saved.

If you have ever made a boo-boo with a database, you can always restore the database easily and quickly.

To restore a database, please do the following:
1. Click Backups.
2. Click the Browse button next to the option which says Restore a MySQL Database.
3. Select the sql file which you would like restored.
4. Click the open button and click the upload button.

This will now upload the sql file which you can see in the MySQL Databases section in cPanel. You can also make changes to it in PhpMyAdmin.

Was this answer helpful?

« Back

Powered by WHMCompleteSolution