Backup helps you to keep your store data in safety and prevent its possible loss or damage as a result of some operations.
Automated Backup and Script Execution options allow to perform database backup and run SQL script according to the schedule configured in advance.
It helps to make copies of the store data in a certain period and keep your data from failure.
In order to configure Automated Backup of a database in the first time, press [Create or Modify Configuration] and launch the simple backup process (see the point about this here).
In the last step save configuration by clicking the relevant button, as shown on the illustration below.
If there is a previously saved configuration you can, in the "Backups" tab, select it from the drop-down list and click [Run Backup] button to launch the process.
This process takes some time. You will see the notification at the bottom of the window:
Now you can add backup to the scheduler, using the corresponding button on the toolbar.
Please note, to be able to perform that you should have the administrative rights in Store Manager. In the timeline form choose the specific period: weekly, daily, monthly, yearly or at once; set the operation time; the day of the week or specific month.
If necessary, at the bottom of the form select the fields on task repetition. Choose the position the most suitable for your needs.
Click on the [OK] to save all settings and start the schedule.
Script Execution tab
In case you need to run SQL scripts frequently, Automated Script Executions option will be useful for you.
Specify SQL script file in the proper field of the wizard.
The next window displays the SQL script of the executable file. Press [Next] button to continue.
If you intend to only restore files, select the relevant field.
Save the current configuration in the corresponding field at the bottom of this window.
Click [Save] button to start the execution of the SQL script file, which you specified on the first step of the Wizard.
- 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.
- serves as task name, time and frequency specification.
Use the other options in the top toolbar to perform the following operations:
- update data in the current page.
- restore over current database.
- remove selected backups or script executions from the list.
- preview backup data or script execution details.
- open the folder, where the file with data is located.
Scheduled task list is the list of tasks that is stored in your Window scheduler. To open it go to Addons / Scheduler Options section and choose [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 the properties of the task, enable/disable the task execution.