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

In This Topic
    MySqlDump Class Members
    In This Topic

    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