How to backup/restore your MySQL database

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 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.

The size limit for any type of backup is 4GB.

You cannot create daily automatic backups with our tools, but you can create a Cron Job if you have a script which does that.

There are no incremental backup tools provided

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

What is a parked domain?

Parked domains are additional domains which you host on your account. They will display the same...

Creating an addon domain

About addon domains Addon Domains are handled like subdomains as far as the server is concerned,...

Error page codes

What are Error Codes? These numbered error codes are how the server tells website visitors...

When will my domain start working?

When will my domain start working? Propagation If you have a new domain name, you must change...

Creating a subdomain

When you create a subdomain in cPanel, you will be asked to choose the name of the subdomain, the...

Powered by WHMCompleteSolution