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 */;
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.