Determines whether to add ALTER TABLE ... DISABLE KEYS clause before INSERT statements.
public bool DisableKeys {get; set;}
'Declaration
Public Property DisableKeys As Boolean
Property Value
true, if ALTER TABLE ... DISABLE KEYS clause should be added before INSERT statements; otherwise,
false. The default value is
false.
This sample demonstrates dumping of two tables (
Dept and
Emp). The script is written to a file after the operation is complete. Performance of the script is improved by disabling the check of constraints.
public void DumpIt(MySqlConnection myConnection)
{
myConnection.Open();
MySqlDump mySqlDump = new MySqlDump();
mySqlDump.Connection = myConnection;
myConnection.Database = "Test";
mySqlDump.DisableKeys = true;
mySqlDump.Tables = "Emp;Dept";
mySqlDump.Backup();
StreamWriter stream = new StreamWriter("d:\\tmp\\mysqldump.dmp");
stream.WriteLine(mySqlDump.DumpText);
stream.Close();
Console.WriteLine("Dumped.");
myConnection.Close();
}
Public Sub DumpIt(ByVal myConnection As MySqlConnection)
myConnection.Open()
Dim mySqlDump As MySqlDump = New MySqlDump
mySqlDump.Connection = myConnection
mySqlDump.DisableKeys = True
mySqlDump.Tables = "Emp;Dept"
mySqlDump.Backup()
Dim stream As StreamWriter = New StreamWriter("d:\tmp\mysqldump.dmp")
stream.WriteLine(mySqlDump.DumpText)
stream.Close()
Console.WriteLine("Dumped.")
myConnection.Close()
End Sub
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2