Determines whether to recreate database objects.
public bool IncludeDrop {get; set;}
'Declaration
Public Property IncludeDrop As Boolean
Property Value
true, if database objects must be recreated; 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. The tables are recreated when executing the script.
public void DumpIt(MySqlConnection myConnection)
{
myConnection.Open();
MySqlDump mySqlDump = new MySqlDump();
mySqlDump.Connection = myConnection;
myConnection.Database = "Test";
mySqlDump.IncludeDrop = 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.IncludeDrop = 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