MySQL: Advanced Options

At the “Target Options” page of SQLWays Wizard you can see the button “Advanced”, which opens the window with additional options for target database:

Table type

This option allows to specify the type of the tables created in MySQL database.

MySQL supports two different kinds of tables: transaction-safe tables (InnoDB and BDB) and not transaction-safe tables (HEAP, ISAM, MERGE, and MyISAM). For example, when InnoDB is selected, SQLWays generates the TYPE=InnoDB clause in the CREATE TABLE statements for MySQL, like:

CREATE TABLE customer (
id INT, name VARCHAR(30)
) TYPE=InnoDB;

Data load option

Data load option combo-box contains the following values: Default, Replace and Ignore. Each of them specifies the behavior of the LOAD DATA INFILE command on the data load into the primary or unique key columns in the table.

• Default - means that the LOAD command rises an error if the key with the same value already exists in the table. When Default is specified in the Wizard nothing is added to the LOAD command syntax.
• Replace - means that the LOAD command replaces the rows of data with the new rows where the primary or unique keys match. The REPLACE keyword is added to the LOAD command syntax.
• Ignore - means that the LOAD command doesn't insert the rows of data where the primary or unique keys match the existing in the table. The IGNORE keyword is added to the LOAD command syntax.

Character Set

Specifies for the loader how to interpret the data stored in the txt file to be loaded to the database. If no character set is specified then the default target database character set is used.

You can choose a character set from the list or enter it manually:

Import from client

This option lets specify whether the data files reside on the local computer or on the MySQL server.

By default the Import from client check-box is selected, so the LOCAL keyword is added for the MySQL LOAD DATA INFILE command that is used for importing data to MySQL. When LOCAL is specified, data files must reside on the client host.

If the Import from client check-box is not selected, the LOCAL keyword is not added to the command and data files must reside on the server.

Preserve comments

By default the Preserve comments check box is not selected. If checked, this option adds to mysql.exe command “–comments”. By default command “–skip comments” used in mysql.exe

Create condition handler

This option was created to emulate the Transact-SQL behavior inside the MySQL stored procedures and functions when the error in one of the statements inside the procedure or function body arises.

By default the Create condition handler check-box is selected. So, SQLWays Wizard adds the CONDITION HANDLER to each “BEGIN…END” block that handles the error arose without terminating the procedure or function execution. The errors are hidden in this case.

When the Create condition handler check-box is unchecked no CONDITION HANDLER is added and the first error encountered during the procedure or function run terminates the procedure or function execution. The error message is returned after the procedure terminates.

Enable local load

This option controls the local data load into MySQL database. By default the Enable local load is selected, so SQLWays Wizard runs the MySQL LOAD DATA INFILE command with the local-infile option, which allows to use LOAD DATA LOCAL command in the .ldi file to load data into the target server from the local machine.

SSL certificate authorities

This option defines the path to a file in PEM format that contains a list of trusted SSL certificate authorities.
By default the SSL certificate authorities is empty.

SSL mode

This option specifies the security state of the connection to the server. By default the SSL Mode is empty, but you can choose other value from dropdown list:

If you have any other questions regarding the usage of our tool, please contact our support team: support@ispirer.com