'Declaration Public Sub EndRestore( _ ByVal result As IAsyncResult _ )
public void EndRestore( IAsyncResult result )
Parameters
- result
- The System.IAsyncResult returned by BeginRestore.
'Declaration Public Sub EndRestore( _ ByVal result As IAsyncResult _ )
public void EndRestore( IAsyncResult result )
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