Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Bug: Copy Database/table Displays Wrong Data

forums forums SQLyog SQLyog: Bugs / Feature Requests Bug: Copy Database/table Displays Wrong Data

  • This topic is empty.
Viewing 5 reply threads
  • Author
    Posts
    • #9789
      TomBez
      Member

      hi there,

      it seems that when using copy database (table) to different host/db the progress display isn't correct after a few seconds. In the first 3-5 seconds the “Copying data for mytable(200 rows completed) is somehow correct, but if than it stops to renew the display. so some people might be puzzled and stop the process, even it works properly. this bug refers to “Copy Database To Different Host/DB” aswell as for “Copy Table To Different Host/DB”.

      regards

      btw: performance for this copyprocess is quite low, making an export database/table as SQL-Statement and an import afterwards is a real lot faster for bigger datavolumns regardless if target and source are on the same machine or not.

    • #22070
      peterlaursen
      Participant

      I am sorry but I cannot reproduce either!

      I just copy a table with 150.000 rows and it (5.16) displays for every 1000 rows. The complete copy process took 4-5 seconds (copy to another computer on LAN).

      Now what do we do from here?

    • #22071
      peterlaursen
      Participant

      I wonder if CPU load is very high due to other tasks running?

    • #22072
      TomBez
      Member
      peterlaursen wrote on Aug 3 2006, 11:49 AM:
      I wonder if CPU load is very high due to other tasks running?

      cpu load is low. have you tried it with InnoDB as storage engine? (i can provide testdata if you need). I'm using sqlyog 5.15

    • #22073
      peterlaursen
      Participant

      I cannot reproduce with InnoDB either.

      Prasad (test enginner) is trying to reproduce/explain the issue!

    • #22074
      peterlaursen
      Participant

      @Tom and @Prasad

      please see ticket 880!

Viewing 5 reply threads
  • You must be logged in to reply to this topic.