Online Documentation for Data Pump for MySQL

Parameter

Description

Product

internal product name

Version

major version

Parameter

Description

ConnectionString

connection string for the data source

Parameter

Description

Line<N>

comment text

Parameter

Description

CommitAfter

number of records after which the COMMIT statement is inserted

DisplayErrorMessages

0 = error messages are hidden in the import log

1 = error messages are displayed in the import log

DetailErrorMessages

0 = simple error messages in the import log

1 = detailed error messages in the import log

ShowTableProgress

0 = simple data import progress in the import log

1 = detailed data import progress in the import log

ConvertNames

0 = object names are not converted

1 = object names are converted to conform to SQL92 naming rules

NamesFormat

nfAsIs = object names are left without changes

nfLowerCase = object names are converted to lower case

nfUpperCase = object names are converted to upper case

ConvertDefaultValues

0 = default values of the source database are not converted

1 = default values of the source database are converted to default values for the destination database

EnableScriptComments

0 = script comments are disabled

1 = script comments are included into the body of the script

DropIfExistDbStatement

the parameter is not used by Data Pump for MySQL

StopScriptOnError

0 = script execution is not stopped on errors

1 = script execution is stopped if an error occurs

ShowExecutedStatements

0 = the Script execution information area does not display any information upon script execution at Step 6

1 = records for successfully executed statements are listed in the Script execution information area at Step 6

AlwaysSkipSuccExecuted

0 = upon subsequent script execution at Step 6 you are prompted to choose whether successfully executed statements should be skipped or not

1 = successfully executed statements are skipped upon subsequent script execution at Step 6

ClearTablesBeforeImport

0 = tables in the MySQL database are not cleared before data import at Step 8

1 = tables in the MySQL database are cleared before data import at Step 8

TrimStringSpaces

0 = source data strings

1 = unused space at the end of source data strings is cut off

QuoteNamesInImportSelQuery

0 = quoting source object identifiers is disabled

1 = quoting source object identifiers is enabled

QuoteTemplate

qtCustom = custom quoting characters (QuoteCharLeft, QuoteCharRight)

qtDefault = the default quotes for the data source in use

qtDoubleQuote = "..."

qtSingleQuote = '...'

qtApostrophe = `...`

qtSquareBracket = [...]

qtRoundBracket = (...)

qtBrace = {...}

qtAngleBracket = <...>

QuoteCharLeft

specifies the left quoting character (if QuoteTemplate = qtCustom)

QuoteCharRight

specifies the right quoting character (if QuoteTemplate = qtCustom)

SchemasMapping

the parameter is not used by Data Pump for MySQL

SchemasMappingExist

the parameter is not used by Data Pump for MySQL

SchemasMappingNew

the parameter is not used by Data Pump for MySQL

GenerateDropTableStmt

0 = no DROP statements are generated

1 = the DROP statements are added for tables in the script

DefaultTableCollation

collation used for the tables by default

DefaultTableType

MySQL table storage engine used for the tables by default

Parameter

Description

Host

host where the target database resides (if Remote = 1)

Login

MySQL login

Password

password to identify the login (encrypted)

RemoteIndex

0 = local connection

1 = remote connection

DataBase

target MySQL database name

DatabaseActions

cdtCreate = a new database is created for pumping data

cdtSelectExisting = an existing database is selected for pumping data

cdtRecreate = an existing database is dropped and then recreated

Charset

client character set specified for the connection

Port

port on which MySQL is listening

UseSSL

0 = SSL protocol is not used

1 = SSL protocol is used for interchanging data with remote MySQL server

UseCompProtocol

0 = compressed data protocol is not used

1 = compressed data protocol is used when connecting to the database server

QuotesIdentifiers

0 = object identifiers are not quoted

1 = object identifiers are quoted with a backquote ('`')

InteractiveMode

0 = wait_timeout variable value from my.cnf file is used for connection timeout

1 = interactive_timeout variable value from my.cnf file is used for connection timeout

TunnelType

indicates the tunneling type being used: SSH, HTTP, or none (TunnelType = ttNotUse)

SSHHostName

name of the host where SSH server is running

SSHPort

port on which SSH server is activated

SSHUserName

user on the machine where SSH server is running

SSHPassword

password to identify SSH server user (encrypted)

SSHKeyFile

path to the Private Key used for the SSH connection (if SSHUseKeyFile = True)

SSHUseKeyFile

True = SSH Private Key is used

False = SSH Private Key is not used

HTTPUrl

URL to the emsproxy.php script file uploaded to your web-server (for HTTP tunneling)

Parameter

Description

Name

table name

TableCollation

collation used for the table

TableType

MySQL table storage engine used for the table (MyISAM, Heap, Merge, InnoDB, Falcon, etc.)

Excluded

1 = the table is excluded from data import at Step 7

WhereClause

text of the WHERE condition for pumping data

Parameter

Description

Name

field name

Type

data type applied to the field

Size

size of the field

Precision

precision for the field values

Default

value that inserted records get by default

NotNULL

0 = nullable

1 = NOT NULL

AutoIncrement

0 = non-autoincrement field

1 = autoincrement field

EnumValues

list of values (for the ENUM and SET data types)

Dimension

0 = dimension properties are not used

1 = dimension properties are used for field types having dimension properties

Unsigned

0 = UNSIGNED attribute is not set for the field

1 = UNSIGNED attribute is set for the field: integer data will be displayed unsigned

ZeroFill

0 = ZEROFILL attribute is not set for the field

1 = ZEROFILL attribute is set for the field: for columns of the numeric data type, MySQL will automatically add zeros before the first significant digit of the number stored in this column

Collation

collation used for the field

Parameter

Description

Name

index name

Unique

0 = non-unique index

1 = unique index

Parameter

Description

Name

key name

DeleteAction

'on delete' rule (for foreign keys):

0 = NO ACTION

1 = RESTRICT

2 = CASCADE

3 = SET NULL

UpdateAction

'on update' rule (for foreign keys):

0 = NO ACTION

1 = RESTRICT

2 = CASCADE

3 = SET NULL

Parameter

Description

{NSP}<schema_name>

excluded schema (if available)

{TBL}<table_name>

excluded table

{IND}<index_name>

excluded index

{FK}<key_name>

excluded key

Parameter

Description

TableCount

number of tables selected for pumping

SrcTableNS<N>

source schema name (if available)

SrcTableNM<N>

source table name

TrgTableNM<N>

target table name

Parameter

Description

SrcField<N>

source field name

TrgField<N>

target field name

FieldCount

number of table fields selected for pumping

Parameter

Description

Line<N>

script text