|
Ispirer SQLWays Database Migration Software
MySQL Advanced Options
This dialog box specifies advanced options for the MySQL target database. The following options are available:
- In the BIN directory box, enter the path to the folder where the MySQL utilities are located. You can click (...) to indicate this folder.
- In the Table type box, select a table type that is used when creating tables in the 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.
- In the Data load option box, select an option to be added to the LOAD command. When Replace is selected existing rows are updated in the existing table basing on primary or unique key information or added to the table if primary key is not matched. When Ignore is selected the existing rows in the table are not updated, when primary or unique key values are equivalent to the existing in the table. The rows from the text file which do not match primary or unique key in the table are inserted.
- By default the Import from client check box is selected, so the LOCAL keyword is generated for the MySQL LOAD DATA INFILE command that is used for importing data to MySQL. When LOCAL is specified, data files can be located on the client host. If the Import from client check box is clear, the LOCAL keyword is not generated and data files must be located on the server before importing.
To specify MySQL options in the command line