2. Automated Backup
Backups help ensure, that your files aren't permanently lost or damaged. With automatic backups, you don't have to remember to backup your database.
‘Automated Backup’ or ‘Script Execution’ tool helps you to backup your database or run SQL script according to the scheduler to save your time and protect your database from failure.
Automated Backup
Use this settings toolbar to perform following operations:
Click “Create or Modify Import Configuration” button to run Backup Wizard and configure settings ;
- run backup with current configuration;
- add backup to the scheduler with current configuration:
In order to add scheduled task, you should have administrative privileges.
Click on "Add Current Backup to Scheduler" button to specify the task name, time and frequency.
You can choose to backup database Daily, Weekly, Monthly or once.
Daily - If you wish to backup your database daily, specify start time and frequency.
Weekly - If you wish to backup your database weekly, specify the time, the day of a week and frequency.
Monthly - If you wish to backup your database monthly, check/uncheck month(s), when you wish to import products, day and start time.
Once - You can backup your database only once when it's more comfortable for you.
- show scheduled tasks list. Scheduled task list is a list of tasks stored in your Windows scheduler.
You can call it, using Addons -> Show Scheduled Tasks.
Here you can find your task to backup your database along with other windows tasks performed regularly.
Here you can add or delete the task, see properties, refresh list and run a task.
- refresh data.
- restore over the 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
In case you need to run SQL scripts frequently, Automated Script Execution tool will be a great solution for you!
NOTE!: Do not run Script, in case you are not sure, that SQL is working properly and will not corrupt your database.
In this section you can find Automated Script Execution settings, which allows you to perform following operations:
Click “Create or Modify Import Configuration” button to run Wizard and configure settings ;
- run script with the current configuration.
- Click on "Add Current Script Execution to Scheduler" button to specify the task name, time and frequency.
- show scheduled tasks list.
Scheduled task list is a list of tasks stored in your Windows scheduler. You can call it, using Addons -> Show Scheduled Tasks. Here you can find your task to backup your database along with other windows, tasks performed regularly.
Here you can add or delete the task, see properties, refresh list and run a task.
You can use the same buttons as in automated backup procedure (refresh, delete, restore etc).