IncludeUsers Property

In This Topic

Determines whether to include GRANT statements for users into the dump text.

This property is obsolete. Use ObjectTypes property instead.

Syntax

Visual Basic
C#

'Declaration
 
Public Property IncludeUsers As Boolean

public bool IncludeUsers {get; set;}

Property Value

true, if GRANT statemets for users should be added into dump text; otherwise, false. The default value is false.

Example

This sample shows how to dump table data and GRANT statements for users.

csharp

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

Visual Basic

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

Reference

MySqlDump Class
MySqlDump Members
ObjectTypes Property

Send Feedback