9.5. Automated Backup
Setting up the automated backup of a database protects store's data from damaging or loss. This sector consists of two tabs:
This page covers the following topics:
The toolbar in the "Backups" tab will help you to perform the following operations:
Create a new configuration of backup (if it is performed for the first time) or modify the existing one.
The first operation launches the wizard. Select the file to automated backup:
Configure necessary data for backup (you can choose tables to backup in accordance with the specified parameters:
You can create your own settings:
In the "Options" window you can choose the data for a backup procedure: all structure of store database, only database files or choose the both options at the same time.
Note: it is significantly slows down the backup process.
By clicking the [Save Settings] button you create a new backup's configuration with the name that was specified in the "Save configuration" field in the "Options" window.
In the top toolbar in the "Configuration" field choose from the drop-down list previously saved configuration, and click [Run Backup] to start the backup procedure.
This process takes some time. When it's finished, the following record will appear at the bottom of the window: "Backup was successfully created":
To save the current backup to the scheduler you should have administrative rights. By clicking [Add Current Backup to Scheduler] you open schedule window.
You have the opportunity to configure automated backup according to your needs. You can select daily, monthly, weekly and once backup of your store database.
Depending on the selected period, you can choose the days of a week, months of a year or temporal parameters of backup.
There are some more options available:
Open Scheduled Tasks Tab.
Restore over current database.
Delete Selected Backup.
Preview backup data.
Open the folder where the file is located.
Adjust columns width, or enable the column auto width.
In case you need to run SQL scripts frequently, the "Automated Script Execution" option will be useful for you.
Specify SQL script file in the relevant field of the wizard. The next window displays the SQL script of the executable file and click the [Next] button to continue.
In the "Options" window choose conditions for performing:
If you want to clear database before executing, select the first checkbox
If you intend to only restore files, select the second checkbox.
You can also select both checkboxes at the same time.
Save the current configuration in the corresponding field at the bottom of this window.
By clicking the [Save] button you start the execution of the SQL script file, that you have specified on the first step of the wizard.
Use the [Run Script] button to run script with the current configuration.
NOTE!: Do not run script, in case you are not sure that SQL is working properly and will not corrupt your database.
This button serves to specify a task name, time and frequency:
This is the list of tasks that is stored in your Window scheduler. To open it go to:
Addons - > Show scheduled tasks
There, you can find your task to backup your database, along with other window tasks performed regularly. Via scheduled tasks’ toolbar you can add new tasks or remove existing ones, launch selected task, view properties of the task, enable/disable task execution.