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

Change your CPanel email quota limit

The quota limit for an address defines the amount of mail (in Megabytes) that can be stored...

How do I create and delete a cron job?

Cron Jobs run scheduled tasks at specific times. This is good to set up automated maintenance...

How Do I Access My Spam Folder?

If you've configured your cPanel hosting account to use the Spam Box feature of SpamAssassin,...

When I upload my website, I still receive the default Under construction page

Make sure you have uploaded to the correct folder. This is the case 99% of the time. The...

Create a email forwarder in Cpanel

Login Cpanel and click on the Forwarders icon     Click on Add Forwarder button    ...