Online Documentation for Data Pump for MySQL

Step 4 - Setting options


At this step of the wizard you can define pump options: database structure conversion options, SQL script execution, data import preferences, server-specific options, and perform source-to-target type mapping.

 

Step 4 - Setting options

 

Convert database structure options

This group of options allows you to customize database structure conversion process.

 

CheckBox Convert names to SQL92 standard

This option brings all the database object names to conformity with SQL92 naming rules.

 

Object names format

The drop-down list allows you to specify whether object names are to be converted to upper/lower case or left without changes (As Is).

 

CheckBox Convert default values

Check this option to convert the default values of the source database to default values for the destination database.

 

Script options

This group of options allows you to customize the SQL script generation and its execution process.

 

CheckBox Enable comments

If this option is selected, comments will be included into the body of the script.

 

CheckBox Show "OK" for successfully executed statements

If this option is selected, records for successfully executed statements will be listed in the Script execution information area at Step 6.

 

CheckBox Always skip successfully executed statements

If this option is selected, all successfully executed statements will be skipped upon subsequent script execution.

 

CheckBox Generate "DROP TABLE" statements

Select the option to add the DROP statements for tables in the script.

 

CheckBox Stop script execution on error

If this option is checked, the script execution will be stopped if an error occurs.

 

Import options

This group of options allows you to customize data import process.

 

CheckBox Clear tables before import data

Select this option to empty the tables in the MySQL database before data import at Step 8.

 

CheckBox Quote source identifiers

This option enables/disables quoting source object identifiers.

If enabled, use the drop-down list to select the preferable value:

  • Default to use the default quotes for the data source being used;
  • one of available quoting patterns: "...", '...', `...`, [...], (...), {...}, <...>;
  • Custom to specify any other characters to be used as left/right quotes.

 

CheckBox Remove trailing spaces

If this option is checked, unused space at the end of source data strings will be cut off.

 

Specific options

This group allows you to define server-specific options.

 

Default table type

Specify the storage engine to be applied to the tables by default (MyISAM, ISAM, MRG_MyISAM, Heap, InnoDB, BDB, Gemini, Arhive, Falcon, etc.).

Note: The drop-down list contains the storage engines supported by the version of MySQL being used.

 

Default table character set

Specify the character set to be used for the tables by default

 

Default table collation

Specify the collation to be used for the tables by default

 

Press the Global type mapping button to open the Type mapping dialog allowing you to view and edit source-target data type correspondences.

 

When you are done, click the Next button to proceed to editing target objects.