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

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

Reference

MySqlDump Class
MySqlDump Members
ObjectTypes Property

Send Feedback