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.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Monitor the servers's status

This can be done in cPanel, in the left hand menu. Scroll to the bottom and find the link for...

What are my nameservers

Not sure what the names servers are for your website's domain name? Kindly refer to the welcome...

How do I add another domain to my Account?

All D-Tech shared Linux hosting plans allow you host multiple domains on the same account. To...

How Do I Create and Remove an Addon Domain?

An addon domain is a fully functional domain that can be created from within your control panel....

How do I manage my Shared hosting account?

We offer cPanel to manage your Shared Web Hosting account. You can learn more about cPanel here