Online Documentation for SQL Manager for MySQL

Setting data options


Use this step of the wizard to set data options of the result file.

Note that this step is skipped if the RadioButton Dump structure only option was selected on the Setting dump options step.

 

Dump database - Setting data options

 

 

CheckBox Add locks around INSERT statements

This option is equivalent to the '--add-locks' option of the mysqldump.

If this option is checked then each table dump is surrounded with LOCK TABLES and UNLOCK TABLES statements.

 

CheckBox Disable keys before dump database

This option is equivalent to the '--disable-keys' option of the mysqldump.

Check this option to surround the INSERT statements with /*!40000 ALTER TABLE tbl_name DISABLE KEYS */; and /*!40000 ALTER TABLE tbl_name ENABLE KEYS */; statements for each table.

 

CheckBox Dump binary strings (BINARY, VARBINARY, BLOB) in hex

This option is equivalent to the '--hex-blob' option of the mysqldump.

If this option is checked then binary columns are dumped using hexadecimal notation.

 

CheckBox Use "INSERT IGNORE" statement

This option is equivalent to the '--insert-ignore' option of the mysqldump.

INSERT IGNORE statements are written instead of INSERT statements in a script.

 

CheckBox Use multiple-row INSERT

This option is equivalent to the '--extended-insert' option of the mysqldump.

Check this option to use multiple-row INSERT syntax that include several VALUES lists. This results in a smaller dump file and speeds up inserts when the file is reloaded.

 

 

Click the Next button to proceed to the Performing operation step of the wizard.