8. Automated Backup
Backups allows to save files of your store from potential damage or removal from database. In order to do this enough go to Automated Backup section of Store Manager and configure it, specifying the duration of the save operation and this function of Store Manager will perform the procedure according to the schedule.
You can also choose the 'Scripts Execution' tab in this section and run QSL scripts according to the schedule that will save your time and protect your database from damage.
You can perform the following operations, using Backups' toolbar:
"Create or Modify Import Configuration" button is used to run Backup Wizard or select from the drop-down list the available import configuration:
"Run Backup" allows to launch Backup procedure with current configuration.
"Add Current Backup to Scheduler" serves to add current backup configuration to a scheduler. You can perform this only with administrator privileges.
"Add Current Backup to Scheduler" is used to configure the frequency of automatic backup. In the form that appears specify task name, time and frequency.
You can choose Daily, Weekly, Monthly or At Once Backup of your database.
"Show Scheduled Tasks" allows to see a list of all scheduled tasks. It is stored in your Window scheduler and you can open it, pressing Addon -> Show Scheduled Tasks option.
A task to automated backup database of your store you can find there.
Using Scheduled Tasks' toolbar you can add new tasks or remove the existing one(s).
- To update the latest changes on the page press 'Refresh' button
- to run task click on 'Run' button or 'Run Task Immediately'
- restore over current database:
- delete selected backup.
- click here to preview backup data.
- open the folder, where this file is located.
- using these buttons you can adjust columns width or set columns auto width.
Script Execution
If you want to run SQL scripts frequently, choose Script Execution tab from the Automated Backup section.
Please note, if you are not sure SQL is working properly and it will not corrupt your database don't run Script!
Script's toolbar is similar to the toolbar of the Backups tab, where you can run the wizard by using 'Create or Modify Import Configuration' button and configure settings; launch script with current configuration; add current Script Execution to scheduler and other operations as in the previous tab.