Reduced by 1% when order is placed
Hurry up to get the best offer!
Rating 0 stars - 0 votes

Magento 2 backup/restore via Store Manager

When rearranging or altering your online store by uploading or updating some data, it is essential to ensure these processes are maintained in a secure way. Some global transformations may damage the whole database of your store, and you will not be able to get its previous version back. Store Manager for Magento provides you with a possibility to backup/restore your Magento 2 database by copying all the data and saving it to file.

Use this article to leran how to backup Magento database and schedule an automatic backup.

In order to begin the backup, find Database Backup/Restore Wizard in the Tools tab on the main toolbar and start it up.

Select Backup Option
Magento 2 Backup Database

Select the necessary action to be performed:

  • Backup current store database;
  • Restore over current store database;
  • Backup multiple stores.

Let’s check each of these processes.

Magento 2 Backup

To start the backup, select the place to save the information to. If you have already performed the backup earlier, you can use saved configuration.

 Indicate the file in which you want to store the backup records
Magento 2 Backup Database

After that specify what tables you want to backup. There are options allowing you to select all tables, clear the selections, invert the selections or make a preset: select products related tables or select customers related products.

Select those database tables you aim to backup
Magento 2 Backup Database

Tick the indicated boxes if you want to backup only database structure (not data itself) or backup the files.

Specify backup options and press Backup to complete the process
Magento 2 Backup Database

To finish the process, press Backup and view the results.

Magento 2 Restore

Select the file to restore data from and specify file charsets. If you have a saved configuration, you can load it.

Restore database from file
Magento 2 Backup Database

Press Next to preview the script, that is going to be executed by the wizard.

Preview the database script
Magento 2 Backup Database

On the last stage of restoring you can force clear database before executing the process and restore the files (the data). To do so, tick the boxes next to these actions.

Put a tick in the checkbox to restore files
Magento 2 Backup Database

Press Restore and have your data restored.

Automated Magento 2 Backup

Magento Store Manager foresaw the tediousness and impracticality of making backups manually each time. It delivers you an opportunity to arrange an automated backup which will be executed according to preset time and using specific configuration.

In order to set an automated backup, you have to create a configuration or change the existing one first. You can proceed with this task by going to the Automated Backup window in the Addons section. To save new settings, simply press Save at the last stage of their creation or modifying.

Create a configuration for Automated Backup
Magento 2 Backup Database

After that add current backup to scheduler and set the tasks of when and how often the automated backup must be performed. If you want to receive e-mail notifications when the task is done, tick the corresponding box and specify your e-mail. Press OK to save the timeline.

Add Task to Scheduler
Magento 2 Backup Database

If you want to avoid spending hours rebuilding your Magento 2 database, security must become an integral part of your store management. Entrust this highly important task to Store Manager and forget about the fear of losing or damaging your data.

Backup and restore Magento 2 database with Store Manager for Magento

Try Now

Related Articles:

how to reindex your magento 2 store tutorial

How to Reindex Your Magento 2 Store

Find out how to set up Magento 2 reindex status and get instructions on performing the reindex in manual mode or using Store Manager. Read More...

Store Diagnostics Troubleshoot Magento Website Problems

Store Diagnostics – Troubleshoot Magento Website Problems

The list of Magento store diagnostics types and their explanation. Read More...

schedule automated cron tasks not overloading your server tutorial

Schedule Automated Cron Tasks Not Overloading Your Server

Check the tips to prevent your Magento server from overload when executing cron tasks. Read More...

magento 2 speed up

Ways to Increase Magento 2 Performance

Use these recommendations to sepeed up your Magento 2. Read More...

Be the first to comment.
Live Chat