How to Backup WooCommerce Database (Complete Guide)

Jul 6, 2020

How to Backup WooCommerce Database (Complete Guide)

Jul 6, 2020

Imagine you get your morning coffee and get to work on your WooCommerce store only to find that your site is down. We know the panic that ensues trying to figure out what’s wrong.

When your website crashes, you lose customers and revenue! Worse, you could lose data such as purchase orders, customer details, and payment information.

Reading this guide “How to Backup WooCommerce Database” is a good call! Backups are a lifesaver. Sooner or later disaster strikes and it’s best to be prepared for it.

Now, WooCommerce sites are different from regular WordPress sites and therefore need a special type of backup.

In this article, we show you exactly how to back up a WordPress WooCommerce site in different ways. We also give you tips on best backup practices for WooCommerce sites that ensure your data is always securely backed up.

TL;DR

The backup needs of a WooCommerce site are very unique from regular sites. BlogVault has a backup solution that is tailored specifically for WooCommerce. Activate BlogVault’s WooCommerce Backup Plugin and get access to real-time automated backups that have a 100% restoration rate.

Factors To Consider When Backing Up WooCommerce

WooCommerce sites aren’t like regular WordPress websites and therefore, their backup needs are very different. To backup your WooCommerce site correctly, you need to know a few factors that are at play:

    1. Files and Database – WordPress is designed for anyone to create a website without knowing the technical inner workings. But it’s important to know that your WordPress site is made up of files and databases. Your files contain site information and configurations, while your database contains posts, pages, users, comments, and the content of your site. You need to back up both elements.
    2. WooCommerce Database Table – Your WordPress database has 11 tables by default. When you use the WooCommerce plugin to power your eCommerce store, it creates its own separate table. Many backup solutions are designed to backup the default WordPress tables and miss the WooCommerce table.
    3. Real-time Data – WooCommerce websites have frequent data changes. Every time a customer signs up, adds items to their cart, or purchases something, new data is generated. Every piece of data is critical to the functioning and success of your online store. Therefore, you need real-time backups that copy every change made to your website instantly.
    4. Working Backups – You need a backup solution that is guaranteed to work when you need to restore your website. If your backup fails to restore your site to normal then it’s of no use.
    5. High Data Volumes – WooCommerce sites tend to have large amounts of data. You need a solution that can backup and store large volumes of data at high speeds.
    6. Downtime – Some backup solutions take hours or days to restore your site. You cannot afford to have any downtime on your site. In case things go wrong, you need a backup solution that minimizes downtime and restores your site in under a few minutes.

Before we show you How to backup the database for a WooCommerce site?, remember, an ideal WooCommerce service should offer all the features above.

In the next section, we’ll show you how to backup your WooCommerce website using a plugin, web host, and manually.

    • Backup Woocommerce Site Using A Plugin
    • Backup Woocommerce Site Using Web Host
    • Backup Woocommerce Site Manually

Backup Woocommerce Site And Database Using A Plugin

There are a number of backup plugins available but not all of them are designed to support WooCommerce sites. As we mentioned, your backup solution needs to copy your files and database in real-time. Further, you need a working backup that can be restored in minutes.

BlogVault offers a comprehensive real-time backup solution specifically designed for WooCommerce websites.

    • It backups files and databases including the custom WooCommerce table.
    • Every change made on your website triggers a backup in real-time.
    • It copies only the changes made instead of the entire site. This incremental backup method makes it faster.
    • It can handle large volumes of data so you never have to worry about the size of your site.
    • It encrypts your backup copy and stores it on secure offsite servers. This ensures your site’s performance and speed is never compromised.
    • The plugin has a 100% restoration rate which means your backups will always work.

To use BlogVault’s WooCommerce Backup solution, follow these steps:

Step 1: Sign up with BlogVault and add your site to the dashboard.

Add site to dashboard

Step 2: The plugin will automatically sync your site and take a backup of your entire site.

Step 3: Enable real-time backups by switching on the toggle.

Enable real-time backups on BV

Now that the plugin is synced with your WooCommerce site, every time a change is made on your site, it will trigger a backup. You can also take a backup on demand if you need one immediately.

When you need to restore your site, you can click on the restore button, select your backup copy and restore your website.

Restore site on BV

Your WordPress WooCommerce backups will run automatically for you. It’s that easy to set up and use.

If this solution isn’t for you, we’ve detailed two more methods you can use to backup your WooCommerce site.

Backup WooCommerce Site And Database With Web Host

Many website owners rely on their web host for backups either because it comes free with their WordPress hosting plan or they find it easier to backup under the same roof as hosting. There are two ways to backup your website using your web host:

    • Automatic Host Backups
    • Manual Host Backups

Automatic Host Backups

Web hosts offer automatic backups solutions either within their hosting package or as an add-on. Some of the web hosts that have automated backups include GoDaddy, Bluehost, Hostgator, Siteground, Dreamhost, and Inmotion hosting.

If your web host offers automated backups, they usually make it very easy to set up from your hosting account.

For instance, with GoDaddy, after you purchase a backup plan, you can visit your hosting dashboard. Go to My Products > Website Security and Backups. Here, you can use the automated function to activate your WordPress backups.

Activate backups on GoDaddy

PRO TIP: Make sure your automated host backup offers the WooCommerce specific features we mentioned above such as real-time backups and reliable restores.

Manual Host Backups

You can also take backups on your own using your web host. The steps may vary from host to host but it generally follows the path below:

Step 1: Log into your hosting account and go to cPanel. Below is how you can access cPanel on NameCheap.

Find cPanel in Namecheap Host

Step 2: Inside cPanel, under Files, select Backup Wizard.

Find Backup Wizard in cPanel

Step 3: Select Backup. Then choose full backup or pick the files you want to backup.

Backup WordPress with Backup Wizard

Step 4: Enter your email address and click on Generate Backup.

How to tell when your WooCommerce site and database backup is done? You’ll receive an email when your backup is complete.

The Backup Wizard usually takes a while to create a backup. Depending on the size of your site, it can take a couple of hours.

Though we’ve detailed this method, we must caution you that it is insufficient. A WooCommerce backup of your store’s database needs real-time backups that are guaranteed to work.

Now, we’ve gone one more method in store for you, but this should be used only if you are familiar with the inner workings of WordPress and know what you’re doing. That said, we’ve covered the exact steps you need to follow to backup your WooCommerce website on your own.

Also Read: How to perform WooCommerce Update?

Backup Woocommerce Site And Database Manually

You can also take a backup of your WooCommerce site on your own. Now, we must CAUTION you, this method is risky. It requires going into the backend of your WordPress store. A slight misstep can cause your site to break. So tread cautiously during this process.

Manual backups are also time-consuming and unreliable. They take a long time to create, an even longer time to restore, and there’s no guarantee that the backup will work.

IMPORTANT: As we mentioned, a WooCommerce site requires real-time backups to ensure you don’t lose any critical information. It’s not feasible to rely on manual backups for your website.

That said, it’s good to learn the manual method of backing up your site. The circumstances are rare but knowing how to take a manual backup may come in handy. If you want to proceed with learning how to manually backup your site, you need to backup two elements of your WordPress site individually:

    • Backup WordPress Files
    • Backup WooCommerce Database

1. Manually Backup WordPress Files In WooCommerce

There are two ways in which you can backup your WordPress files – via cPanel and FTP. We’ll show you how to use both.

a) Manually Backup WordPress Files In cPanel

Step 1: Log into your hosting account. Go to cPanel > File Manager.

Step 2: Locate the public_html folder. You will see three subfolders called wp-admin, wp-content, and wp-includes.

public html folder in cpanel

Step 3: On the right panel, Select All the files and folders, right-click to get a drop-down menu. Select Compress.

Compress files in cpanel

Step 4: On the next page, choose Zip Archive. This will reduce the size of the files to make the process faster. Once the zip file is ready, select and Download it.

Download zip archive from cpanel

This zip file will download to your local computer. Store it securely.

If you don’t have access to cPanel on your hosting dashboard, no worries. You can use an FTP client to carry out the same process.

b) Manually Backup WordPress Files Via FTP

Using FTP can be complicated at first, but we’ve included detailed instructions below that should help simplify it.

Step 1: Fetch FTP Credentials

To access your website, you need to use an FTP username and password. You can find these details in your web hosting account.

If you are unable to find them, use this guide to Find your FTP Credentials or contact your web host’s customer support.

Step 2: Download an FTP client

An FTP client is a third-party software that allows you to establish a connection between your local computer and your website’s server. There are many FTP clients available such as FileZilla and Cyberduck. We’ll use Filezilla to demonstrate the next steps.

Step 3: Connect to Your Website

Open FileZilla and enter your FTP credentials on the top bar.

Step 4: Download Your Backup

Once you’ve established a connection, you will see two panels. On the left, you can see your local computer. On the right panel, your website’s files and folders will populate.

Go to the public_html folder, right-click and Download it. If you host more than one website on the same server, you will see the different website names. Select your website’s folder, right-click, and select Download.

A zip file of your website’s files will begin downloading to your local computer. In our experience, this method takes excruciatingly long. We don’t recommend using FTP to create a backup for a regular website let alone a WooCommerce site.

Use this method only if you want a copy of your files, but it’s insufficient to secure your WooCommerce site.

As we mentioned, copying your WordPress WooCommerce files is only half the job done. Next, you need to download your website’s database.

2. Manually Backup Database via phpMyAdmin

Step 1: Go to your hosting account > cPanel > Databases > phpMyAdmin.

phpmyadmin

Step 2: Inside phpMyAdmin, select Databases, and choose your website’s database.

Databases in phpmyadmin

PRO TIP: If you don’t know your database name, you can find it in your wp-config file. Go to cPanel > File Manager > public_html. Here, you can locate your wp-config file. Right-click and select Edit. You can find your database name as shown below:

Database name in wp config

Step 3: Select the correct database in phpMyAdmin, then Select All the tables on the right panel.

Database tables

Step 4: You’ll be directed to a page where you can select the export method and format. Leave it at its default settings Quick method and SQL format. Then hit Go.

Export method in phpmyadmin

A .sql file will download onto your local computer. Store it securely along with the zip file we downloaded earlier.

That’s it! You’ve successfully created a manual backup. To restore the backup you just created, you can follow our detailed guide on how to restore a manual backup.

Remember that the backup copy of your website stores all the information on your WooCommerce store. If a hacker gets their hands on an unsecured backup, they can exploit it. It’s extremely critical that you secure your backup by encrypting it and storing it in a safe location.

This is why we strongly recommend that you use a backup solution that will handle security of your backups for you.

Final Thoughts

Setting up a WooCommerce site is no easy task. It requires a sizable amount of time, investment, and effort.

Unfortunately, there are unavoidable risks such as your website crashing, malfunctioning, and getting hacked. This makes backups extremely crucial to the success of your online store.

Out of the different backup methods we covered in this guide, the most reliable solution is using a plugin like BlogVault.

The plugin will take automated backups of all your data. It takes care of secure storage and gives you a quick and reliable auto restore process.

Backup Your WooCommerce Site With BlogVault!

how backup woocommerce store
Share via
Copy link