How to backup/restore your MySQL database

If you run a database driven website, it is important to backup your databases, periodically. So, here is how to backup just your databases.

To backup the databases please do the following:

1. Login to your control panel and 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 saved, locally.

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

1. Login to your control panel and click Backups.
2. Click the Browse button next to the option which says Restore a MySQL Database.
3. Select the .sql.gz file which you want restored.
4. Click the Open button and click the Upload button.

Your database driven website should be working again.


Was this answer helpful?

 Print this Article

Also Read

What should I do if denied access via FTP?

Make sure you are using the correct username and password to login via ftp. If you are sure...

How do i backup my site in cPanel?

It is important to have your own backup procedure in place to protect yourself from losing all...

Add email address

To add a new email address: Type the email address to be created in the Email field....

How do I create a MySQL database, a user, and then delete if needed?

Create: If you are using any type of PHP software or keeping a collection of records which need...

Create a subdomain in cpanel

You have the ability to create subdomains in cPanel. Sub domains function separately from your...