Backup File Settings - Automatic Backup Scheduler for MySQL
Task Wizard
Automatic Backup Scheduler for MySQL > Help Document > Task Wizard > Backup File Settings

Backup File Settings


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

  1. 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.
  2. 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.
  3. 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.



See also:
  1. Task - Back up MySQL databases to the SQL files
  2. Task - Back up MySQL databases to the other server
  3. Task - Back up a MySQL database to the other database
  4. Task - Restore MySQL databases from the backup files
  5. Task - Restore MySQL databases from the other server
  6. Task - Restore a MySQL database from the other database
  7. Task - Execute SQL Script
  8. Page - MySQL Server
  9. Page - Source Server and Database
  10. Page - Destination Server and Database
  11. Page - Select Databases
  12. Page - Select Source Items
  13. Page - Add Backup Files
  14. Page - Recovery Databases
  15. Page - Backup Files
  16. Page - Upload Backup Files
  17. Page - Execute SQL script before starting and after ending
  18. Page - Enter SQL Script
  19. Page - Task Scheduler
  20. Options - MySQL Database Advanced Settings
  21. Options - Compression Options
  22. Options - Back up Tablespaces
  23. Options - SMTP Options
  24. Protocol - SSL Protocol
  25. Protocol - SSH Tunneling
Copyright © 2024 Database Think Software. All rights reserved.