Bug: Copy Database/table Displays Wrong Data

[TomBez]

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.

[peterlaursen]

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?

[peterlaursen]

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

[TomBez]

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

[peterlaursen]

I cannot reproduce with InnoDB either.

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

[peterlaursen]

@Tom and @Prasad

please see ticket 880!

[Author]

Posts