MySqlDump Constructor()

In This Topic

Initializes a new instance of the MySqlDump class.

Syntax

Visual Basic
C#

'Declaration
 
Public Function New()

public MySqlDump()

Remarks

The base constructor initializes all fields to their default values.

Example

This sample shows how to use MySqlDump object to create a backup of two tables.

csharp

public void DumpIt(MySqlConnection myConnection)
{
  myConnection.Open();
  MySqlDump mySqlDump = new MySqlDump();
  mySqlDump.Connection = myConnection;
  myConnection.Database = "Test";
  mySqlDump.IncludeDrop = true;
  mySqlDump.Tables = "Dept;Emp";
  mySqlDump.Backup();
  StreamWriter stream = new StreamWriter("d:\\tmp\\mysqldump.dmp");
  stream.WriteLine(mySqlDump.DumpText);
  stream.Close();
  Console.WriteLine("Dumped.");
}

Visual Basic

Public Sub DumpIt(ByVal myConnection As MySqlConnection)
  myConnection.Open()
  Dim mySqlDump As MySqlDump = New MySqlDump
  mySqlDump.Connection = myConnection
  myConnection.Database = "Test"
  mySqlDump.IncludeDrop = True
  mySqlDump.Tables = "Dept;Emp"
  mySqlDump.Backup()
  Dim stream As StreamWriter = New StreamWriter("d:\tmp\mysqldump.dmp")
  stream.WriteLine(mySqlDump.DumpText)
  stream.Close()
  Console.WriteLine("Dumped.")
End Sub

Reference

MySqlDump Class
MySqlDump Members
Overload List

Send Feedback