How to Backup & Restore MySQL Database in cPanel

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.
  • 12 Users Found This Useful
Was this answer helpful?

Related Articles

How to create a Reseller WHM

You must have a VPS or Dedicated Server with root WHM to do this.1. Login to WHM and click the...

How do I backup my website?

1. Login to cPanel2. Click on Backups3. Click Download or Generate a Full Web Site Backup4....

How to reset a reseller's client's password

1. Go to WHM and click Password Modification (under Account Functions). 2. Select the account...

How to Suspend and Unsuspend an account in WHM?

1) Login into your WHM control panel and click on the “Accounts Function”. 2) Scroll...

Could not exec shell '/bin/bash' with errno = 2

If you are receiving alerts like the following regarding your cPanel cronjob's then this article...

Powered by WHMCompleteSolution