MySqlDumpProgressEventArgs getting the progess example

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
nickwood
Posts: 4
Joined: Mon 22 Aug 2005 01:13

MySqlDumpProgressEventArgs getting the progess example

Post by nickwood » Mon 22 Aug 2005 01:16

Hi all does anyone have a working example of this progress class as I cant seem to figure out from the help manual how to get it to work and there are no examples there either.

Any help would be most appreciated.

Serious

Post by Serious » Mon 22 Aug 2005 07:12

MySqlDump.Progress event behaves like common .NET event. Here is a simple example on how to use it:

Code: Select all

    public static void WriteProgress(object sender, MySqlDumpProgressEventArgs args) {

      Console.WriteLine("ObjectType:\""+ args.ObjectType + "\" Name:\"" + args.ObjectName + "\" Object #" + args.ObjectNumber + "/" + args.ObjectCount + " Progress:" + args.Progress.ToString() + "/" + args.MaxProgress.ToString());
    }

    [STAThread]
    static void Main(string[] args) {

      MySqlConnection connection = new MySqlConnection("host=localhost;database=test;user id=root;password=root;");
      MySqlDump dump = new MySqlDump();
      dump.Connection = connection;
      dump.Tables = "dept";
      dump.IncludeDrop = true;
      connection.Open();
      try {
        dump.Progress += new MySqlDumpProgressEventHandler(WriteProgress);
        dump.Backup();
        dump.Restore();
      }
      finally {
        connection.Close();
      }
    }

nickwood
Posts: 4
Joined: Mon 22 Aug 2005 01:13

Not Familiar with C

Post by nickwood » Mon 22 Aug 2005 07:20

Hi Serious,,

Thanks for the reply, I should have mentioned that I am using vb and I dont know C very well at all (if at all). I tried to convert what you gave me with no luck. Do you have an example in vb at all.

Thanks for your help


Nick

Serious

Post by Serious » Mon 22 Aug 2005 07:39

Actually that was a C#. Anyway, here is my quick translation to VB.NET:

Code: Select all

Imports CoreLab.MySql

Module Module1

  Sub WriteProgress(ByVal sender As Object, ByVal args As MySqlDumpProgressEventArgs)
    Console.WriteLine("ObjectType:" + args.ObjectType + " Name:" + args.ObjectName + " Object #" + args.ObjectNumber.ToString() + "/" + args.ObjectCount.ToString() + " Progress:" + args.Progress.ToString() + "/" + args.MaxProgress.ToString())
  End Sub

  Sub Main()
    Dim connection As MySqlConnection = New MySqlConnection("host=server;port=3307;database=test;user id=root;password=root;")
    Dim dump As MySqlDump = New MySqlDump
    dump.Connection = connection
    dump.Tables = "dept"
    dump.IncludeDrop = True
    connection.Open()
    Try
      AddHandler dump.Progress, New MySqlDumpProgressEventHandler(AddressOf WriteProgress)
      dump.Backup()
      dump.Restore()
    Finally
      connection.Close()
    End Try
  End Sub

Post Reply