General Options

Log to file:
Records detailed information on every error (indicating success or failure) that occurred during the transfer process.

Note: This log will be overwritten on each transfer.

Related topic:
Log Files

Server Options

Flush log files before starting Data Transfer
Runs FLUSH LOGS statement on the source server before running data transfer.

See also:
Flush

Lock tables before read
Locks the tables in the source database so that any update on the table is not allowed once the data transfer is triggered off.

Continue on errors
Ignores errors that are encountered during the transfer process.

Create database if not exist
Creates a new database if the database specified in target server does not exist.

Table Options

Create tables
Creates tables in the target database with this option is on.

Supposes this option is unchecked and tables already exist in the target database, then all data will be appended to the destination tables.

Include all table create options
If this option is on, table create options will be included.

Example with Include all table create options being disabled

CREATE TABLE `users`(
`ID Number` bigint(11) NOT NULL DEFAULT '0',
`User Name` text ,
`User Age` varchar(255) NOT NULL ,
PRIMARY KEY (`ID Number`)) TYPE=MyISAM;

Example with Include all table create options being enabled

CREATE TABLE `users` (
`ID Number` bigint(11) NOT NULL default '0',
`User Name` text,
`User Age` varchar(255) NOT NULL default '',
PRIMARY KEY (`ID Number`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Drop tables before create
Check this option if tables already exist in the target database, the existing tables will be deleted once the data transfer starts.

Create triggers
Creates triggers in the target database with this option is on.

Record Options

Create records
Check this option if you require all records to be transfered to the destination database.

Use delayed insert
Inserts records using DELAYED insert SQL statements.

Example:
INSERT DELAYED INTO `users` VALUES ('1', 'Peter McKindsy', '23');
INSERT DELAYED INTO `users` VALUES ('2', 'Johnson Ryne', '56');
INSERT DELAYED INTO `users` VALUES ('0', 'katherine', '23');

Use complete insert statements
Inserts records using complete insert syntax.

Example:
INSERT INTO `users` (`ID Number`, `User Name`, `User Age`) VALUES ('1', 'Peter McKindsy', '23');
INSERT INTO `users` (`ID Number`, `User Name`, `User Age`) VALUES ('2', 'Johnson Ryne', '56');
INSERT INTO `users` (`ID Number`, `User Name`, `User Age`) VALUES ('0', 'katherine', '23');

Use entended insert statements
Inserts records using extended insert syntax.

Example:
INSERT INTO `users` VALUES ('1', 'Peter McKindsy', '23'), ('2', 'Johnson Ryne', '56'), ('0', 'Katherine', '23');

Add locks when inserting records
Locks the tables in the target database before inserting records.

Use hexadecimal format for BLOB
Inserts BLOB data as hexadecimal format.