When set to true, all data in the table will be inserted within a single SQL statement. This form of INSERT statement requires less amount of data to transfer and may execute faster.
public void DumpIt(MySqlConnection myConnection) { myConnection.Open(); MySqlDump mySqlDump = new MySqlDump(); mySqlDump.Connection = myConnection; myConnection.Database = "Test"; mySqlDump.UseExtSyntax = 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.UseExtSyntax = 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