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

Can I view my site before it has propagated to your servers?

Yes! You can view your website on our servers while you wait for the nameservers to update by...

How can I contact support?

Our dedicated support team is on hand and ready to answer any questions you may have about your...