ExportAll Property

In This Topic

Determines whether to export functions, procedures, and views together with tables.

This property is obsolete. Use ObjectTypes property instead.

Syntax

Visual Basic
C#


'Declaration Public Property ExportAll As Boolean


public bool ExportAll {get; set;}

Property Value

true, if functions, procedures, and views DDL statements should be added to dump text; otherwise, false. The default value is false.

Remarks

This property allows you to perform complete backup of database.

Example

csharp


public void DumpAll(MySqlConnection myConnection) { myConnection.Unicode = true; myConnection.Open(); MySqlDump mySqlDump = new MySqlDump(); mySqlDump.Connection = myConnection; mySqlDump.Database = "Test"; mySqlDump.ExportAll = true; mySqlDump.Backup("d:\\tmp\\mydump.dmp"); myConnection.Close(); Console.WriteLine("Dumped."); }

public void DumpAll(MySqlConnection myConnection)
{
  myConnection.Unicode = true;
  myConnection.Open();

  MySqlDump mySqlDump = new MySqlDump();

  mySqlDump.Connection = myConnection;
  mySqlDump.Database = "Test";

  mySqlDump.ExportAll = true;

  mySqlDump.Backup("d:\\tmp\\mydump.dmp");

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

Visual Basic


Public Sub DumpAll(ByVal myConnection As MySqlConnection) myConnection.Unicode = True myConnection.Open() Dim mySqlDump As New MySqlDump mySqlDump.Connection = myConnection mySqlDump.Database = "Test" mySqlDump.ExportAll = True mySqlDump.Backup("d:\tmp\mydump.dmp") myConnection.Close() Console.WriteLine("Dumped.") End Sub

Public Sub DumpAll(ByVal myConnection As MySqlConnection)
  myConnection.Unicode = True
  myConnection.Open()
  Dim mySqlDump As New MySqlDump
  mySqlDump.Connection = myConnection
  mySqlDump.Database = "Test"
  mySqlDump.ExportAll = True
  mySqlDump.Backup("d:\tmp\mydump.dmp")
  myConnection.Close()
  Console.WriteLine("Dumped.")
End Sub

Reference

MySqlDump Class
MySqlDump Members
ObjectTypes Property

Send Feedback