9.5. Automated Backup

fmAutoBackupRestorefmBackupRestoreWizardfmAddSchedulerTaskfmWindowsTaskList

Setting up the automated backup of a database protects store's data from damaging or loss. This sector consists of two tabs:

  • "Backups"
  • "Script Executions"

This page covers the following topics:

Backups

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:

Database backup file

Configure necessary data for backup (you can choose tables to backup in accordance with the specified parameters:

Database tables

You can create your own settings:

Create new preset
Invert Selection button

You may use invert for your selection etc.

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.

Save backup configuration
  • 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.
Add current backup to scheduer

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.

Scheduler type

Depending on the selected period, you can choose the days of a week, months of a year or temporal parameters of backup.

Script Execution

In case you need to run SQL scripts frequently, the "Automated Script Execution" option will be useful for you.

Script execution

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:

  1. If you want to clear database before executing, select the first checkbox
  2. 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.

Run Script

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.

Add current Script Execution

This button serves to specify a task name, time and frequency:

Script Execution form
Refresh button

< - Refresh backup data

Restore button

< - Restore over current database

Delete button

< - Remove selected backups

Preview button

<- Preview backup data

Open folder button

< - Open folder with the backup file

Adjust column width

< - Use these options to adjust the width of columns.

Scheduled Tasks

Thi is the list of tasks that is stored in your Window scheduler. To open it go to:

Addons - > Scheduler Options - > Show scheduled tasks

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.

Scheduled Tasks toolbar