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. ).

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...

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