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

Select Source Items


This page shows all items on the source MySQL database for exporting. You can select any items of MySQL ( Tables, Views, Triggers, Stored Procedures, Functions and Events ) in the source database list and set up the advanced options ( flush, lock, using hexadecimal notation, etc. ).
Select Source Items

  1. Source Database: All of the items on the source MySQL database will appear in the source database list, including 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 items.
    1. 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 source database, the software will automatically add the newly created items and remove the dropped items from the source database list of the task for exporting , you don't need to edit the task manually.
    2. Table Structure: Export the structure of the tables selected in the source 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.
    3. Table Records: Export the records of the tables selected in the source 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.
  2. Select All: Select all of the items in the source database list.
  3. Deselect All: Deselect all of the items in the source database list.
  4. Invert: It will change the current selections that are previously unselected to be selected and vice versa.
  5. Refresh: The software will reconnect to the MySQL server and retrieve the source database list.
  6. Advanced Settings: Set up the advanced options to optimize the input or output. We advise you to use the default values. Read More...




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 - 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 © 2017 Database Think Software. All rights reserved.