How to backup and restore a MYSQL databse in cPanel

Since the Bizzy Boutique online store builder software is databse driven, it is important to run periodic backups on the databases. 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:

    Login to your cPanel and click on the Backups icon.
    Under "Download a MySQL Database Backup", click the name of the database.
    Click Save As.
    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:

    Login to your cPanel and click on the Backups icon.
    Click the Browse button next to the option which says Restore a MySQL Database.
    Select the .sql.gz file which you want restored.
    Click the Open button and click the Upload button.

  • Navigating Your cPanel, Website Maintenance
  • 4 Users Found This Useful
Was this answer helpful?

Related Articles

How do I upgrade or downgrade my account level?

To upgrade or downgrade your ecommerce hosting plan, follwing these instructions:1. Log into your...

What are my name servers?

The nameservers for your new Bizzy Mama ecommerce website hosting plan have been sent over in...

Why do I see a suspended page when I visit my service domain?

If you are seeing a suspended page when you visit your domain, you may be behind on your...

What is propagation?

Propagation is the projected length of time it takes for root name servers and cache records...

How do I setup my new email address in my email client?

To help get your email accounts set up in your preferred email client, we have complied the...