28
*Reduced by 1% after each order
Rating 0 stars - 0 votes

WooCommerce Database Backup/Restore

Management of an online store usually requires performing regular transformations of its database. However, implementing any global changes to your store may be rather dangerous because of the risk to lose or damage the whole database or a part of it. That’s why it is strongly recommended to backup your store data before making some serious alterations.


WooCommerce Database Backup and Restore Wizard
WooCommerce Database Backup and Restore Wizard

With the help of Store Manager for WooCommerce it is possible to make such global processes secure using the built-it backup/restore wizard. There are a couple of backup actions you can accomplish via the assistant:

  • Backup current store database (save it into .sql);
  • Restore over current database;
  • Backup multiple stores.

Let’s go deeper into all of these ways to secure your store database. To begin, find Database Backup/Restore wizard on the main toolbar.

WooCommerce Database Backup

Start up the Wizard and specify the place to save the .sql file to. You can also load a saved configuration to avoid reconfiguring the settings each time.



WooCommerce Backup Saving Location
WooCommerce Backup Saving Location

Next you have to select database fields you need to backup. You can select only those fields that are related to products using the preset drop-down.


WooCommerce Tables for Backup in Store Manager
WooCommerce Tables for Backup in Store Manager

Specify what part of your database exactly you want to backup:

  1. Database structure only (not data);
  2. Database fIles.

It is possible to select both of these options at one time, if needed. In order to save the configuration, specify it’s name and press "Save Configuration".


WooCommerce Database Backup Options
WooCommerce Database Backup Options

Press "Backup" and preview the backup results.


WooCommerce Database Backup Finish Step
WooCommerce Database Backup Finish Step

WooCommerce Database Restore

Database restore process is almost identical to the backup. The first step requires you to select the place to save the restore results to or to use a saved configuration. You can leave the default file charset or specify another one.


WooCommerce Backup File Location for Restore
WooCommerce Backup File Location for Restore

Preview the database script which is going to be executed by the Wizard. If it is correct, press "Next".


Backup Restore Script in Store Manager for WooCommerce
Backup Restore Script in Store Manager for WooCommerce

Select the actions to be performed during the restore:

  • Force clear database before the restore;
  • Restore files.

You can tick the both boxes and save all settings to use them next times. To finish the process, press "Next".

WooCommerce Automated Database Backup

To avoid setting up of your store database backup each and every time, Store Manager for WooCommerce provides you with the opportunity to schedule this process for it to be performed automatically on a regular basis.


Automated WooCommerce Backup Configuration
Automated WooCommerce Backup Configuration

To start the automated backup, you have to create or modify the existing configuration and save it.


Saving WooCommerce Backup Configuration for Automated Task
Saving WooCommerce Backup Configuration for Automated Task

After that press "Add current backup to scheduler" and set the parameters including the start time and frequency of its executing. You can also arrange only one-time backup, selecting Once in the Schedule task drop-down.

To save the settings, press "OK".


WooCommerce Database Backup Scheduler in Store Manager
WooCommerce Database Backup Scheduler in Store Manager

Let WooCommerce Store Manager provide your store database with high-level security for you to feel confident when accomplishing any global actions.

Backup your WooCommerce database now!

Try Now

COMMENTS
Be the first to comment.