EPUB | CHM | PDF

TMySQLDump.Properties

Top Previous Next

Please see TMySQLDump properties short descriptions below:

CompleteInsert

An option to include the field names in "insert" command

Database

Points to TMySQLDatabase component which sets a DB to be connected with.

Delimiter

Sets the SQL statements delimiter.

DisableKeys

Generates "ALTER TABLE <TableName> DISABLE KEYS" SQL statements.

DisableUniqueChecks

Generates SQL statements to disable uniqueness checks for secondary indexes in InnoDB tables.

DropObject

Generates DROP TABLE SQL statement.

DumpOption

Sets DB dump type.

ExcludeTables

Exclude the contents of specified tables from dump process.

ExtInsert

Generates INSERT SQL Statement using extended syntax.

ExtInsertsCount

Sets the number of <FIELDVALUES> sections for single INSERT statement with extended syntax.

IgnoreLockTables

Exclude the 'LOCK TABLE' clause of specified tables from dump process.

IncludeHeader

Sets if the dump information will be written at the beginning of the SQL file.

Limit

Sets maximum number of rows to be retrieved from server at once during dumping tables.

LineComment

Sets the line comment string for SQL statements.

LockTables

Specifies whether to add "LOCK TABLE" clause to the dump script.

RewriteFile

Sets SQL file opening mode.

SQLFile

Sets a full path to a file with SQL script will be generated.

TableList

Sets a list of DB tables to be dumped.

UseCreateDB

Generates CREATE DATABASE SQL statements.

UseHexBlob

Specifies whether to use hexadecimal notation when dumping binary columns.