Gets or sets number of SQL statements to execute before issuing COMMIT when restoring data from a dump.
public int CommitCount {get; set;}
'Declaration
Public Property CommitCount As Integer
Property Value
Number of SQL statements to execute before issuing COMMIT. The default value is 0.
public void RestoreIt(MySqlConnection myConnection)
{
myConnection.Open();
MySqlDump mySqlDump = new MySqlDump();
mySqlDump.Connection = myConnection;
mySqlDump.CommitCount = 3;
StreamReader stream = new StreamReader("d:\\tmp\\mydump.dmp");
mySqlDump.Restore(stream);
stream.Close();
myConnection.Close();
Console.WriteLine("Restored.");
}
Public Sub RestoreIt(ByVal myConnection As MySqlConnection)
Dim mySqlDump As New MySqlDump
myConnection.Database = "Test"
myConnection.Open()
mySqlDump.Connection = myConnection
mySqlDump.CommitCount = 3
Dim stream As New StreamReader("d:\tmp\base.dump")
mySqlDump.Restore(stream)
stream.Close()
myConnection.Close()
Console.WriteLine("Restored.")
End Sub