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:

Automated Backup Section

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:

Create or Modify Configuration

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

Select database tables to export

You can create your own settings:

Create filter for backup

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 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":

Choose and Run Backup
  • 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 Scheduler

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.

General Task Settings

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:

Show Scheduled Tasks
  • Open Scheduled Tasks Tab.

Regresh Data
  • Refresh data.

Restore over current database
  • Restore over current database.

Delete Selected Backup
  • Delete Selected Backup.

Preview backup data
  • Preview backup data.

  • Open the folder where the file is located.

Adjust columns width
  • Adjust columns width, or enable the column auto width.

Script Execution

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

Script Executions

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.

Restore options

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.

Run restoring script

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

Add Current Script to Scheduler

Scheduled Tasks

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

Addons - > 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 options