EPUB | CHM | PDF

TMySQLDump.Properties.DisableKeys

Top Previous Next

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

Syntax:

property DisableKeys: Boolean default False;

Description:

Set DisableKeys property value to True to generate the following SQL statements.

In dump script header:

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

In dump script footer:

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

Before table dump:

/*!40000 ALTER TABLE <TableName> DISABLE KEYS */;

After table dump:

/*!40000 ALTER TABLE <TableName> ENABLE KEYS */;

tip Disabling foreign key checking can be useful for reloading InnoDB tables in an order different from that required by their parent/child relationships. Take a look at MySQL Manual for details.