Backup File Settings

In Backup File Settings, you can set up How Many Files, File Name Format and Automation Deletion.

How Many Files: The files will be created when the task is running.
1. One file contains all of selected databases: The software will back up all of the selected databases to a single file each time.
2. Each file contains a selected database ( Multiple files ): The software will back up different databases to different files. It will create multiple files if you select multiple databases. Every file contains a separate database, it's very convenient to restore a single database from the backup file.
Bckup Files
1. File Name Format: The name format of the backup files. You can enter a name or use the MACRO variables to create a new backup file every time. The files will be created when the task is running. You can use the following MACRO variables:
  1. %TASKNAME%:The name of the current task you entered on Step 1.
  2. %HOST%: The name of the MySQL server( e.g. www.databasethink.com ).
  3. %DATE%: The date when the file is created ( in the "YYYY-MM-DD" format ).
  4. %TIME%:The time when the file is created ( in the "HH-MM-SS" format ).
  5. %DATABASE%: The name of the source database.
2. Create a new folder each time for storing the backup files ( named by DATE_TIME ): If you check the option, the software will create a new subfolder under the selected folder to store the backup files every time. The name of the subfolder is based on the date and time when the subfolder is created. The subfolder will be created when the task is running.
Automation Deletion: You can select one option at most.
1. Automatically delete the expired backup files after some days: The software automatically delete the expired backup files after some days ( e.g. 7 days ) since it created.
  Note: It doesn't work for differential backup.
2. Automatically delete the oldest backup files every some full backup copies: The software automatically delete the oldest full backup copies of the current task when the total number of full backup copies of the task is greater than some full backup copies (e.g. 7 full backup copies).

Reset to default: Reset all of the Backup File Options to the default values.