Select Databases - Automatic Backup Scheduler for MySQL
Task Wizard
Automatic Backup Scheduler for MySQL > Help Document > Task Wizard > Select Databases

Select Databases


This page shows all databases and items on the source MySQL server for exporting. You can select any items of MySQL ( Databases, Tables, Views, Triggers, Stored Procedures, Functions and Events ) in the database list and set up the advanced options ( flush, lock, using hexadecimal notation, etc. ). You can choose the backup type ( full, incremental and differential ) and set up the options.
Select Databases

  1. Database List : All of the databases information on the source MySQL server will appear in the database list, including databases, tables, views, triggers, stored procedures, functions and events. If you select an item, all child items of the current item will be selected, and vice versa. Please note that the current user must have enough privileges to show the databases.
    1. Table Structure: Export the structure of the tables selected in the database list, those are the CREATE table statements. If you check the option and uncheck Table Records, the exported data will only contains the CREATE table statements and without INSERT statements.
    2. Table Records: Export the records of the tables selected in the database list, those are the INSERT statements. If you check the option and uncheck Table Structure, the exported data will only contains the INSERT statements and without CREATE table statements.
    3. Always back up all of updates on the source server: When you create or drop any items ( Databases, Tables, Views, Triggers, Stored Procedures, Functions, Events, etc. ) from the source server, the software will automatically add the newly created items and remove the dropped items from the database list of the task for exporting, you don't need to edit the task manually.
    4. Always back up all of updates of the current database: When you create or drop any items ( Tables, Views, Triggers, Stored Procedures, Functions, Events, etc. ) from the current database, the software will automatically add the newly created items and remove the dropped items from the database list of the task for exporting, you don't need to edit the task manually.
  2. Select All: Select all of the items in the database list. After clicking, it will be Deselect All. Click it again, all of the items in the database list will be deselected.
  3. Refresh: The software will reconnect to the MySQL server and retrieve the database list.
  4. Enter a database: If you have not enough privileges to show the databases on the server, the database list will be blank. You can enter a database name which you need to export and have enough privileges to access. The items in the database will automatically appear in the database list.
    Enter a database
  5. Advanced Settings: Set up the advanced options to optimize the input or output. We advise you to use the default values. Read More...
  6. Back up Tablespaces: Choose if back up the tablespaces or not. If the server permits tablespaces and you need to back up them, please choose the option. Read More...
  7. Backup Type: It only works for backup tasks. Read more about enable the binary logs for MySQL incremental / differential backup.
    1. Full Backup: The software will back up all selected items every time. Read More...
    2. Incremental Backup: The software will back up all updated records from the selected items since the last full, differential or incremental backup. Read More...
    3. Differential Backup: The software will back up all updated records from the selected items since the last full backup. It is not available in the Back up MySQL databases to the other server task. Read More...
      Click Settings to set up the Incremental / Differential Backup Options.
      Incremental / Differential Backup Options
      1. Don't make any full backups except first time: It only make a full backup at the first time.
      2. Make a full backup every some Incremental / Differential backups: The first time is a full backup and then the software will make a full backup every some times.
        Note: After changing the settings of Incremental / Differential Backup by editting the task, the software will ask if you want to make a full backup again.




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 Source Items
  12. Page - Add Backup Files
  13. Page - Recovery Databases
  14. Page - Backup Files
  15. Page - Upload Backup Files
  16. Page - Execute SQL script before starting and after ending
  17. Page - Enter SQL Script
  18. Page - Task Scheduler
  19. Options - MySQL Database Advanced Settings
  20. Options - Backup File 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.