Determines whether to add comments into the dump text.
public bool GenerateHeader {get; set;}
'Declaration
Public Property GenerateHeader As Boolean
Property Value
true, if comments should be added into dump text; 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 script text is made more readable.
public void DumpIt(MySqlConnection myConnection)
{
myConnection.Open();
MySqlDump mySqlDump = new MySqlDump();
mySqlDump.Connection = myConnection;
myConnection.Database = "Test";
mySqlDump.GenerateHeader = 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.GenerateHeader = 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