DAC for MySQL

TMySQLDump.Properties

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.

ExtInsert

Generates INSERT SQL Statement using exteded syntax.

ExtInsertsCount

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

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.

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.