In this tab, you can view the server and database information. Enter a comment for the backup file if necessary.
In this tab, choose database objects you wish to backup.
All <objects> during execution (*) |
All the database objects being backed up, all newly added database objects will also be backed up without amending the backup profile. |
Custom |
Only the checked database objects will be backed up. However, if you add any new database objects in the database and/or schema after you create your backup profile, the newly added database objects will not be backed up unless you manually modify the Objects list. |
Note: The following options depend on the connection server type and sort in ascending order.
Lock All Tables
Lock all objects while backup is being processed.
Use Single Transaction (InnoDB only)
If a table uses InnoDB storage engine, with this option is on, Navicat uses transaction before the backup process starts.
Use specify file name
Define your file name for backup. Otherwise, your backup file will be named with "YYYYMMDDhhmmss" format.