Gets or sets a value that indicates which database objects will be included in the dump text.
The following example dumps only triggers and events from the 'Test' database.
static void Main(string[] args) {
MySqlConnection connection = new MySqlConnection("user id=root;password=root;host=localhost;port=3306;database=Test");
connection.Open();
MySqlDump mySqlDump = new MySqlDump(connection);
mySqlDump.ObjectTypes = MySqlDumpObjects.Triggers | MySqlDumpObjects.Events;
mySqlDump.Backup("D:\temp\mydump.dmp");
connection.Close();
Console.WriteLine("Dumped.");
Console.ReadKey();
}
Sub Main()
Dim connection As MySqlConnection = New MySqlConnection("User Id=root;Password=root;Host=localhost;Port=3306;Database=Test;")
connection.Open()
Dim mySqlDump As MySqlDump = New MySqlDump(connection)
mySqlDump.ObjectTypes = MySqlDumpObjects.Triggers Or MySqlDumpObjects.Events
mySqlDump.Backup("D:\\temp\\mydump.dmp")
connection.Close()
Console.WriteLine("Dumped.")
Console.ReadKey()
End Sub