Database Property (MySqlDump)

In This Topic

Gets or sets database to dump data from.

Syntax

Visual Basic
C#


'Declaration Public Property Database As String


public string Database {get; set;}

Property Value

Database to dump data from.

Remarks

When Backup is executed it tries to determine in what database the tables are located using property Database. If this property is empty, Database property of associated MySqlConnection is used. If this property is empty too Backup method raises exception.

Example

csharp


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

public void DumpIt(MySqlConnection myConnection)
{
  myConnection.Open();

  MySqlDump mySqlDump = new MySqlDump();

  mySqlDump.Connection = myConnection;
  mySqlDump.Database = "Test";
  mySqlDump.Tables = "Dept;Emp";

  StreamWriter stream = new StreamWriter("d:\\tmp\\mydump.dmp");
  mySqlDump.Backup(stream);
  stream.Close();

  myConnection.Close();
  Console.WriteLine("Dumped.");
}

Visual Basic


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

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

Reference

MySqlDump Class
MySqlDump Members
Restore Method
Backup Method

Send Feedback