[New] Introducing Duplicator’s Sleek Redesign: New Look, Same Great Features
We simplified backups and migrations with Duplicator's fresh new look. Dive into our redesigned interface, backup presets, helpful tooltips, and…
[New] Introducing Duplicator’s Sleek Redesign: New Look, Same Great Features
Joella Dunn
Joella Dunn
John Turner
John Turner
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!
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.
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.
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.
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.
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 » General.
Now you can back up your WooCommerce database!
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 » Backups » Add New.
Name the backup with dynamic tags. If you want to send your backup to the cloud, choose a cloud storage location.
To limit the backup to just database files, click on the Database Only preset. However, keep in mind you can also create custom backups that include the media library, active plugins, and other files.
Hit Next. Duplicator will scan your WooCommerce store and alert you of any issues.
Click on Create Backup.
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 Schedule Backups page. Then, create a new schedule.
Name the backup schedule. To customize what data is included in the backup, add a 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.
Go back to the new schedule screen and select the new backup 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.
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.
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.
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.
This opens a pop-up, allowing you to instantly roll back to the previous version.
However, you might face a bigger 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.
Once you set disaster recovery, copy the recovery link or download the recovery launcher file.
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.
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:
Choose SQL as the file format. Hit Go to download your 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.
This will download your WordPress files to your computer. Compress them into a zip file and save them in a safe place.
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.
You’ll see several backup choices including a database backup. For cPanel, click on your database name under Download a MySQL 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.
You can back up your WooCommerce site 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.
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.
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 Backups page.
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
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!
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.
