IncludeDrop Property

In This Topic

Determines whether to recreate database objects.

Syntax

Visual Basic
C#

'Declaration
 
Public Property IncludeDrop As Boolean

public bool IncludeDrop {get; set;}

Property Value

true, if database objects must be recreated; otherwise, false. The default value is false.

Remarks

"DROP TABLE IF EXISTS" or "DROP DATABASE IF EXISTS" will be added before "CREATE TABLE" or "CREATE DATABASE" if IncludeDrop property is set to true.

If Devart.Data.MySql.MySqlDump.IncludeDatabase is set to true, the database is also deleted (DROP DATABASE IF EXISTS) before executing the script, so use this option with caution, because the tables you do not specify in Devart.Data.MySql.MySqlDump.Tables property will be lost.

Example

This sample demonstrates dumping of two tables (Dept and Emp). The script is written to a file after the operation is complete. The tables are recreated when executing the script.

csharp

public void DumpIt(MySqlConnection myConnection)
{
  myConnection.Open();
  MySqlDump mySqlDump = new MySqlDump();
  mySqlDump.Connection = myConnection;
  myConnection.Database = "Test";
  mySqlDump.IncludeDrop = 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
  mySqlDump.IncludeDrop = 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

DbDump Class
DbDump Members

Send Feedback