'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
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