dotConnect for MySQL Documentation
Devart.Data.MySql Namespace / MySqlDump Class
Properties Methods Events

MySqlDump Class Members

The following tables list the members exposed by MySqlDump.

Public Constructors
 NameDescription
Public ConstructorOverloaded. Initializes a new instance of the MySqlDump class.  
Top
Public Properties
 NameDescription
Public PropertyGets or sets the max size in bytes of a single insert statement with multiple values in the script. This property is ignored if the UseExtSyntax property is set to false.  
Public PropertyGets or sets number of SQL statements to execute before issuing COMMIT when restoring data from a dump.  
Public PropertyGets or sets the MySqlConnection used by this instance of the MySqlDump.  
Public Property (Inherited from System.ComponentModel.Component)
Public PropertyGets or sets database to dump data from.  
Public PropertyDetermines whether to add ALTER TABLE ... DISABLE KEYS clause before INSERT statements.  
Public PropertyOverridden. Gets as a result of Backup() execution, or sets data needed to execute Restore() method.  
Public Property

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

This property is obsolete. Use ObjectTypes property instead.

 
Public PropertyDetermines whether to add comments into the dump text. (Inherited from Devart.Common.DbDump)
Public PropertyDetermines whether to dump BLOB columns using hexadecimal notation.  
Public Property

Determines whether to include information about database into the dump text.

This property is obsolete. Use ObjectTypes property instead.

 
Public Property

Determines whether to exclude users that don't have privileges on the specified Database.

 
Public PropertyDetermines whether to recreate database objects. (Inherited from Devart.Common.DbDump)
Public PropertyDetermines whether to add LOCK TABLE clause before data insertion.  
Public PropertyDetermines whether to add USE statement to the script.  
Public Property

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

This property is obsolete. Use ObjectTypes property instead.

 
Public PropertyDetermines whether to include data from tables into the dump text, script to create database objects or both. (Inherited from Devart.Common.DbDump)
Public PropertyGets or sets a value that indicates which database objects will be included in the dump text.  
Public PropertyDetermines whether to quote all identifiers present in the database. (Inherited from Devart.Common.DbDump)
Public Property (Inherited from System.ComponentModel.Component)
Public PropertyOverridden. Gets or sets a list of the tables which will be used in the script. Table names are separated by semicolon.  
Public PropertyDetermines whether to use INSERT DELAYED statement syntax.  
Public PropertyDetermines whether to use extended syntax of INSERT on data insertion.  
Top
Public Methods
 NameDescription
Public MethodOverloaded. Generates a script and writes it to the DumpText property. (Inherited from Devart.Common.DbDump)
Public MethodOverloaded. Generates a script with a backup of the data, returned by the specified query, and writes it to the DumpText property. (Inherited from Devart.Common.DbDump)
Public MethodOverloaded. Starts an asynchronous invocation of a Backup method. (Inherited from Devart.Common.DbDump)
Public MethodOverloaded. Starts an asynchronous invocation of a BackupQuery(String) method. (Inherited from Devart.Common.DbDump)
Public MethodOverloaded. Starts an asynchronous invocation of a Restore method. (Inherited from Devart.Common.DbDump)
Public Method (Inherited from System.MarshalByRefObject)
Public Method (Inherited from System.ComponentModel.Component)
Public MethodEnds an asynchronous invocation of the Backup method. (Inherited from Devart.Common.DbDump)
Public MethodEnds an asynchronous invocation of the BackupQuery method. (Inherited from Devart.Common.DbDump)
Public MethodEnds an asynchronous invocation of the Restore method. (Inherited from Devart.Common.DbDump)
Public Method (Inherited from System.MarshalByRefObject)
Public Method (Inherited from System.MarshalByRefObject)
Public MethodOverloaded. Executes script specified in the Devart.Common.DbDump descendant property. (Inherited from Devart.Common.DbDump)
Public Method (Inherited from System.ComponentModel.Component)
Top
Public Events
 NameDescription
Public Event (Inherited from System.ComponentModel.Component)
Public EventOccurs when a SQL statement within dump script has produced an error.  
Public EventOccurs when MySqlDump processes next database object or SQL statement.  
Top
See Also