dotConnect for MySQL Documentation
Devart.Common Namespace / DbDump Class / EndBackup Method
The System.IAsyncResult returned by BeginBackup.
Example

In This Topic
    EndBackup Method
    In This Topic
    Ends an asynchronous invocation of the Backup method.
    Syntax
    'Declaration
     
    Public Sub EndBackup( _
       ByVal result As IAsyncResult _
    ) 
    public void EndBackup( 
       IAsyncResult result
    )

    Parameters

    result
    The System.IAsyncResult returned by BeginBackup.
    Remarks
    The function ends an asynchronous backup that is started with BeginBackup. A pair of asynchronous functions (BeginBackup and EndBackup) can be used instead of the synchronous function Backup to gain more performance and flexibility in your application.
    Example
    This sample demonstrates performing async backup and restore operations.
    public void DumpIt(MySqlConnection myConnection) {
            myConnection.Open();
            MySqlDump mySqlDump = new MySqlDump();
            mySqlDump.Connection = myConnection;
            myConnection.Database = "Test";
            mySqlDump.IncludeDrop = true;
            mySqlDump.GenerateHeader = true;
            mySqlDump.Tables = "Dept;Emp";
            IAsyncResult myResult = mySqlDump.BeginBackup("d:\\tmp\\mysqldump.dmp");
            while (!myResult.IsCompleted) {
                    Console.Write(".");
                    //Perform here any operation you need
            }
            mySqlDump.EndBackup(myResult);
            Console.WriteLine("Dumped.");
            myConnection.Close();
    }
    
    public void UnDumpIt(MySqlConnection myConnection) {
            myConnection.Open();
            MySqlDump mySqlDump = new MySqlDump();
    
            mySqlDump.Connection = myConnection;
            myConnection.Database = "Test";
            IAsyncResult myResult = mySqlDump.BeginRestore("d:\\tmp\\mysqldump.dmp");
            while (!myResult.IsCompleted)
            {
                    Console.Write(".");
                    //Perform here any operation you need
            }
            mySqlDump.EndRestore(myResult);
            Console.WriteLine("Restored.");
            myConnection.Close();
    }
    Public Sub DumpIt(myConnection As MySqlConnection)
            myConnection.Open()
            Dim mySqlDump As New MySqlDump()
            mySqlDump.Connection = myConnection
            myConnection.Database = "Test"
            mySqlDump.IncludeDrop = True
            mySqlDump.GenerateHeader = True
            mySqlDump.Tables = "Dept;Emp"
            Dim myResult As IAsyncResult = mySqlDump.BeginBackup("d:\tmp\mysqldump.dmp")
            While Not myResult.IsCompleted
                    'Perform here any operation you need
                    Console.Write(".")
            End While
            mySqlDump.EndBackup(myResult)
            Console.WriteLine("Dumped.")
            myConnection.Close()
    End Sub
    
    Public Sub UnDumpIt(myConnection As MySqlConnection)
            myConnection.Open()
            Dim mySqlDump As New MySqlDump()
    
            mySqlDump.Connection = myConnection
            myConnection.Database = "Test"
            Dim myResult As IAsyncResult = mySqlDump.BeginRestore("d:\tmp\mysqldump.dmp")
            While Not myResult.IsCompleted
                    'Perform here any operation you need
                    Console.Write(".")
            End While
            mySqlDump.EndRestore(myResult)
            Console.WriteLine("Restored.")
            myConnection.Close()
    End Sub
    Requirements

    Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

    See Also