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.");
}

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

Reference

MySqlDump Class
MySqlDump Members
Restore Method
Backup Method

Send Feedback