DisableKeys Property

In This Topic

Determines whether to add ALTER TABLE ... DISABLE KEYS clause before INSERT statements.

Syntax

Visual Basic
C#

'Declaration
 
Public Property DisableKeys As Boolean

public bool DisableKeys {get; set;}

Property Value

true, if ALTER TABLE ... DISABLE KEYS clause should be added before INSERT statements; otherwise, false. The default value is false.

Remarks

When inserting large blocks of data on large tables, setting this property to true makes the script generated much faster.

This feature is affects MySQL servers of version 4.0 and higher.

Example

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.

csharp

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();
}

Visual Basic

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

Reference

MySqlDump Class
MySqlDump Members

Send Feedback