9.1. Database Backup/Restore
Maintaining a backup and/or restore of your store database is not only a good practice but a real necessity. Database backup allows recovering lost, or corrupted data, either partially, or totally, in the case of an operating system, software, or hardware failure. It also offers a level of protection for problems due to human mistakes, that can damage, or make the database inoperative, and the data inaccessible.
The backup and recovery wizard provides facilities for configuring a number of possible database restore scenarios.
With the Restore Wizard, you may:
Backup the current Store database
Restore over the current database
Backup multiple databases
Database Backup and Restore can be accessed through the Tools menu.
To perform a database backup, open the Database Backup/Restore Wizard:
1. Select Backup current store database.
Important! To avoid issues with the database, we strongly recommend using Direct connection to perform the backup/restore operations.
2. Select a file to save your database backup.
3. Select tables that you wish to backup. If you have chosen to backup the entire database, all tables will be checked. In addition, you may select, or unselect them manually. Subsequently, you may restore from backup, or restore default database with initial data, to restore your data to a stable, prior state.
It is also possible to save only a database structure (tables with no data). You may also select Copy, Create Statements, and the underlying SQL statements will be saved within the backup file.
Note: The [Next >] button click will save the script into a previously selected file.
4. The next page will present the opportunity to preview your changes. If it is necessary to create a backup with different settings, the Wizard may be run again.
To Restore a Database, start the Database Backup/Restore Wizard:
1. Select [Restore over current database], and press [Next] to proceed.
2. Specify a file for your database backup, to be restored from.
3. Preview the script you wish to restore from. Also, the current database may be cleared, before restoring.
[Force Clear DB, before executing] precludes the possibility that some current database data, not mentioned in the script, might stay as is.
Important! By clicking the [Next >] button, you will start the "Restore" process from the prior file selected.
4. On the following page, you will be able to check and review any errors that may have occurred during script extraction.
Database Backup/Restore for Magento Store Manager for MAC
Database backup/restore section represents the information on the current connection, last backups list and the options for running backup/restore wizard and/or automated backup operation below.
Run backup/restore by clicking the lower option:
Backup Store Database
Backup database serves to save your current database in the SQL script separately to avoid loss of data and be able to restore the database structure, if necessary.
Backup/Restore actions can be found in the top menu of Store Manager window in the "Tools" tab:
Select an action from the "Welcome" page:
You will move to the step where you can select necessary tables from the current database that will be saved during backup process. Use the preset from the drop-down list:
With the option for adding you can create your own preset and use it for the selection:
To delete selected preset, press an option for removal, as it is illustrated.
The next stage displays the field with the full path to a file where the database backup will be placed in. It is generated automatically using the default location, but you can specify your own way, as well:
Take into account the field below:
If it is unselected, the only structure of the database will be saved (the tables will be empty). This backup is not acceptable for further restoring.
To be able to restore the entire store database, mark with the tick the relevant checkbox before proceeding to the next stage.
Select additional data to backup. The hidden form of the Advanced Settings can be expanded with a click on the following sign:
Please take into account, the more data is checked and involved to the backup, the more time will be taken to complete the process.
To return the settings to the default positions, press the corresponding option in the lower side of the current form:
The option to start the backup you can be found on the next step:
The upper rows show the progress of the current process and the lower screen - the steps of the backup with the time indication.
The completion of the process shows the 100% mark displayed in the top ribbons of the form:
Press [OK] to close the wizard. The process of backup is finished now.
Restore Over Current Database
Select an action in the wizard that you can find at the top Store Manager’s menu:
To start restoring, press the command from the drop-down list:
The script file with the database backup should be specified in the field, on the next step. Use the browse button to find a necessary path:
Take a note, current field is required and should be filled.
Once a backup is done, you will see information, as it is shown on the preview screen.
To be able to restore the content of the database, select the option at the bottom of the form:
Click on [Next] to proceed.
The following step launches the restoring and monitors the progress of the process:
The notification about process completion will be shown in the upper ribbon.
The restoring is finished and the wizard can be closed now.
After a database is restored, from a backup file, it will only allow users to access the data that was available, prior to the time that the backup file was created. Any, and all, database changes, made from subsequent points, are lost.