Get the Best WordPress Backup
& Migration Plugin Today
Get Duplicator Now
Announcement for Duplicator's new inline help

[NEW] Introducing Inline Help to Clarify Backups and Migrations

Are you not sure what the Duplicator plugin can do? You can now use inline help to immediately find answers…
How to backup WooCommerce database

How to Back Up a WooCommerce Database (3 Easy Methods for 2024) 

Written By: author image Joella Dunn
author image Joella Dunn
Joella is a writer with years of experience in WordPress. At Duplicator, she specializes in site maintenance — from basic backups to large-scale migrations. Her ultimate goal is to make sure your WordPress website is safe and ready for growth.
     Reviewed By: John Turner
reviewer image John Turner
John Turner is the President of Duplicator. He has over 20+ years of business and development experience and his plugins have been downloaded over 25 million times.

Are you not sure how to back up your WooCommerce database?

Frequent backups give you peace of mind that you’ll never lose data to hacks, errors, or downtime. When you have a backup of your WooCommerce store, you can immediately restore product and customer data if it’s ever deleted.

In this step-by-step tutorial, we’ll show you how to back up a WooCommerce database!

Why You Should Back Up Your WooCommerce Database

Imagine opening up your WooCommerce store, only to find it in chaos. Product data? Gone. Customer information? Vanished. All the hard work you’ve put into building your online store, down the drain. 

Well, that’s where a WooCommerce database backup comes into play! It’s your safety net if anything goes wrong.  

You never know when you might get hacked or an error destroys your data. If this happens, restore a clean backup of your live site to instantly get your store back online and avoid permanent data loss. 

The longer your WooCommerce store is offline, the more sales you lose. Having a backup means you can get your site back up and running quickly, minimizing downtime.

Want to try out a new plugin, but worried it might mess up your store? With a backup, you have the freedom to experiment, knowing you can restore your store if things go awry.

How to Back Up Your WooCommerce Database

By now, you’ll probably want to back up your WooCommerce database, but you might not know how to do it. Let’s explain three different methods you could use to make this happen.

Method 1: Use a WooCommerce Backup Plugin

Backups are only effective if you create them consistently. If you forget to back up your site, you won’t have a copy of your WooCommerce database to restore.

For this reason, we’d recommend using a backup plugin instead of the manual route. Options like Duplicator Pro allow you to automate backups so you never have to worry about losing customer or product data. 

Step 1: Install Duplicator Pro

Duplicator Pro is a backup and migration plugin that seamlessly integrates with WooCommerce. You can use this powerful tool to create WooCommerce backups and even move your entire store when you need to.

Duplicator Pro plugin

Unlike other backup plugins, Duplicator supports many cloud storage providers like Wasabi, Amazon S3, and Google Cloud. It also gives you easy restore options to quickly recover your store after issues.

With the free version, you can easily back up your WordPress database. However, consider upgrading to Duplicator Pro to access secure cloud storage, one-click restores, and other helpful features.

After purchasing a subscription, install and activate Duplicator in WordPress. To start using the premium version, you’ll also need to activate your license key in Duplicator Pro » Settings » Licensing:

Activate Duplicator Pro license key

Now you can back up your WooCommerce database!

Step 2: Create a Database Backup

Even if you’re new to WordPress, Duplicator makes it extremely simple to create backups of your online store. To get started, find Duplicator Pro » Packages » Create New:

Create new backup

Name the backup or keep the automatically generated name. If you want to send your backup to the cloud, choose a cloud storage location:

Duplicator backup storage locations

Duplicator supports all of these third-party cloud services:

To limit the backup to just database files, expand the Archive section and click on Database Only. However, keep in mind you can also create custom backups that include the media library, active plugins, and other files.

Backup WordPress database

Hit Next. Duplicator will scan your WooCommerce store and alert you of any issues:

Duplicator package scan

Click on Build to start the backup process of your WooCommerce database!

Step 3: Set Up Automatic Backups

By now, you’ll have a real-time backup of your WooCommerce database. However, you’ll get new orders and customers, so you’ll have to consistently back up your site. 

To make sure your store continues to be protected, the next step is to set up automatic backups. This ensures you always have a recent backup, preserving your online store’s functionality. 

All you’ll need to do is find Duplicator’s Schedules page. Then, create a new schedule:

Create website backup schedule

Name the backup schedule. To customize what data is included in the backup, add a new package template:

Create new backup template

You can customize this the same way you created a backup earlier. If you only want to protect the database, build a database-only template:

Database backup template

Go back to the new schedule screen and select the new package template.

Next, decide where you want to store backups. You’ll see a local storage option, as well as any cloud services you’ve connected:

Amazon S3 automatic backup schedule

Duplicator allows you to set automatic monthly, weekly, hourly, or daily backups. For each of these options, you’ll have advanced settings like specific days of the month or week:

Duplicator automatic backup schedule

Finally, enable the schedule and save it. Your WooCommerce database is now protected!

You can create as many schedules as you need to. You might want to back up the database more frequently, but make sure you have full backups as well.

Custom backup schedules

Step 4: Have a Disaster Recovery Plan

Backups are great to have, but you’ll need to know how to restore them. Fortunately, Duplicator has you covered.

Whenever you see an error on your site, go to the most recent backup. Hit the Restore button:

Duplicator restore button

This opens a pop-up, allowing you to instantly roll back to the previous version:

Duplicator one-click restore

However, you might face a more large-scale issue that locks you out of your WordPress dashboard. When this happens, you won’t be able to access the one-click restore feature.

To prepare for the worst, be sure to set up disaster recovery. This allows you to restore your site without logging into WordPress.

First, find your latest full-site backup. Click on the disaster recovery icon next to it:

Duplicator disaster recovery

Once you set disaster recovery, copy the recovery link or download the recovery launcher file:

Disaster recovery link

If disaster strikes, all you need to do is paste the recovery link into a new browser window. Or, simply open the recovery file. This immediately restores your site:

Disaster recovery

Method 2: Manually Back Up Your Database

If you want a more hands-on approach, you can create a manual backup. However, this can be more time-consuming and difficult to configure.

To back up your database, sign into a database manager like phpMyAdmin. Click on your database name. If you’re not sure of your database credentials, this information is in your wp-config.php file.

Then, find the Export tab:

phpMyAdmin export

Choose SQL as the file format. Hit Go to download your database!

Export WordPress database

To fully restore your WordPress site after a site-wide error, you’ll also need a copy of your files. To download your WooCommerce files, sign into a file manager like cPanel or an FTP client like FileZilla.

Find your public_html directory and select all of the files in it. Next, download them:

Download site files

This will download your WordPress files to your computer. Compress them into a zip file and save them in a safe place.

Method 3: Use Your Web Host to Back Up Your Database

Many web hosting providers offer backup services which include database backups. 

Firstly, log into your hosting provider’s account. Look for the control panel – this could be cPanel, Plesk, or something similar, depending on your hosting provider. For this tutorial, we’ll be using cPanel. 

Here, find the Backup option. This is usually located under the files section. But, this may vary depending on your host’s setup. 

cPanel backups

You’ll see several backup choices including a database backup. For cPanel, click on your database name under Download a MySQL Database Backup:

cPanel database backup

Now, your WooCommerce database is safe and sound. If you’re unsure about any steps, don’t hesitate to reach out to your web host’s customer support. 

FAQs About Backing Up Your WooCommerce Database

How do I back up my WooCommerce store?

You can back up your WooCommerce site by creating a package with Duplicator. Feel free to include everything in your e-commerce store or limit it to just a database-only backup. After the backup is created, download it.

Alternatives: Other backup/restore plugins include UpdraftPlus, BlogVault, BackupBuddy, and Jetpack.

How do I export all data from WooCommerce?

To export all data from WooCommerce, install the Duplicator Pro plugin. Then, create a full backup of your online store. You can use this file to migrate your WooCommerce store to a new host, domain, or server.

If you want to only export WooCommerce products or orders, you could use the Import Export Suite, which is a WooCommerce add-on. Another effective tool is WP All Import. 

How do I migrate my WooCommerce website?

If you need to migrate your WooCommerce website, Duplicator Pro is the best tool. You’ll simply need to create a complete backup of your online store. Then, upload this backup to the new location by dragging and dropping it into the Import page.

Import website archive

If you don’t already have WordPress installed, upload your backup archive and installer files to the new server. Launch the Duplicator installer by pasting this link into a new web browser:

https://your-domain/installer.php

Duplicator deploy installation

Conclusion

By now, your WooCommerce database will be backed up!

While you’re here, you may also like these WordPress tutorials:

Are you ready to protect your customer and order data? Download Duplicator Pro today to set up automatic database backups and restore them whenever you need to!

author avatar
Joella Dunn Content Writer
Joella is a writer with years of experience in WordPress. At Duplicator, she specializes in site maintenance — from basic backups to large-scale migrations. Her ultimate goal is to make sure your WordPress website is safe and ready for growth.

Disclosure: Our content is reader-supported. This means if you click on some of our links, then we may earn a commission. We only recommend products that we believe will add value to our readers.