Rating 0 stars - 0 votes

Magento Database Backup and Restore

Magento store handling involves regular data changes carrying out, it’s obvious. Web merchants can’t go without recurrent Magento catalog updates, data import, images upload, etc. These operations are fundamental and at the same time influence overall store database.

So far as each of data arranging operations can keep step with inaccuracies or mishaps, that can damage database, you should protect data and bypass possible malfunctions. For that very reason maintaining Magento backup database and its restore is becoming more of demand for each and every store proprietor.

Backup can be defined as the process of data copying and storage on purpose to reconstitute in case original information is lost or corrupted and should be characterized by accuracy and consistency of its accomplishing.

Spot-on and recoverable database backup is being performed via Store Manager for Magento application. It possesses convenient Database Backup/Restore wizard, that allows in an instant make a copy of data and save information to the file.

With Store Manager you have the possibility to easily:

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

Important note!

To perform database backup when working with Bridge type of connection, you should uncheck "Optimize Speed" option and Get data from web to retrieve all database tables. On these terms, there are several points to consider during making backup on the mentioned type of connection, namely:

  1. If you have edited your bridge.php file and excluded some tables, you should disable those exceptions.
  2. if there are some changes made on your store side during database backup - it may lead to backup and restore issues/errors due to database mismatch.

Considering the points mentioned above, we recommend making a database backup on Direct type of connection to avoid possible inconveniences.

Optimize Speed option during Magento backup
Magento Database Backup and Restore

Performing Magento Backup

To commence on database backup process, start up the wizard. It’s being disposed in Store Manager Tools section. The wizard tool being opened, you have to heedfully go through each and every step it includes.

Start Magento Database Backup Wizard
Magento Database Backup and Restore

Step 1. Select required option in initial window, either backup current database or backup multiple stores option.

Select Backup Option
Magento Database Backup and Restore

Step 2. On this stage of Magento database backup you are to indicate the file, records will be stored to.

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

Step 3. In current window of the wizard you derive all the database tables listed. Select those you aim to backup. On condition that you have selected entire database backup option, all the tables will be checked. You may check or uncheck boxes for certain tables depending on your needs.

Select those database tables you aim to backup
Magento Database Backup and Restore

Step 4. This step of database backup foresees you to specify backup option/s - backup database structure only (without data) or backup files. It’s also possible to save configured backup settings on purpose to use them for upcoming backups carrying out. Press Backup button below to complete the process.

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

View outcomes in the last window of the wizard.

View outcomes in the last window of the wizard
Magento Database Backup and Restore

How to Configure Automated Backup

With Store Manager for Magento you can make the process of catalog backing up mechanized and you won’t run it manually each time. Data backups will be performed automatically at predefined time, according to scheduled task created.

To set up automated Magento backup you must do the following:

  1. Create new configuration or alter that, created previously. Actually, this procedure comprises actions, described above.
  2. Create scheduler task, using configuration created. In Add Schedule Task window you are to specify task settings - define task name and select needed configuration from the drop-down. The field below stands for indicating schedule details - time and recurrence of backup accomplishing. The process can be undertaken daily, weekly, monthly or one time only.
How to Configure Automated Backup
Magento Database Backup and Restore

The Procedure of Database Restore

To recover data you are to proceed with several simple actions.

  1. Launch data restore wizard and choose Restore Over Current Database option at the initial step.
  2. Restore over current database
    Magento Database Backup and Restore

  3. Specify the file, database will be restored from.
  4. Restore database from file
    Magento Database Backup and Restore

  5. View database scripts in the preview window.
  6. Designate backup options and press Restore to accomplish the procedure.

Backing up Magento files is of great importance, as it can prevent you from accidental data loss or database corruption. Proceed with flawless data backups and restores using Store Manager functionality.

Download Store Manager FREE and try its advanced functionality yourself Get It Now

Related Articles:

Card image

How to Reindex Your Magento 2 Store

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

Card image

Magento 2 SEO Features

The ultimate guide on Magento 2 SEO optimization (XML map generation, meta tags optimization, speed up tools, product reviews etc...) Read More...

Card image

How to Perform Automated Product Import

Schedule Magento import to be accomplished on hourly, daily or weekly basis using the saved configuration. Read More...

Card image

Store Diagnostics – Troubleshoot Magento Website Problems

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

Luis • 12/30/2019

Is it also applicable for taking the Magento 2 backup? Because I've found a resource that explains how to take backup through admin Magento admin panel. It would be great if you update your content.

Magento Store ManagerMod Luis • 12/30/2019

Hello, Luis!
Thank you for your commment.
As Store Manager is compatible with Magento 2, taking a backup of this version of the shopping cart is possible as well.
Concerning the update of the content - we will consider your suggestion.