Long Heidi freeze when exporting databse

lemon_juice's profile image lemon_juice posted 10 years ago in General Permalink
I have one table that consistently freezes Heidi for several minutes when I try to export it. Heidi.exe process keeps consuming all CPU and the mysql process appears to be idle then - when I first did the export I thought heidi froze for good and exported the db with SqlYog. SqlYog exports the same table in a few seconds - the table is only 27 MB and has 500 000 rows.

I can send you the data if you can look into this.
ansgar's profile image ansgar posted 10 years ago Permalink
Please send to the email found on the imprint page.
lemon_juice's profile image lemon_juice posted 10 years ago Permalink
Okay, I've just sent it!
ansgar's profile image ansgar posted 10 years ago Permalink
My HeidiSQL r4827 eports that file in 8 seconds:

This is quite ok.
1 attachment(s):
  • export-piwigo
lemon_juice's profile image lemon_juice posted 10 years ago Permalink
Indeed, this must have been some bug in earlier Heidi versions, I experienced this problem consistently in build 4822 - the export took about 2 minutes. Today I upgraded to build 4827 from the 32-bit installer and exporting this table is fast - also 8 seconds. I don't know what happened between 4822 and 4827 because I don't see anything export related in the changelog. But it's good it works fine again.
ansgar's profile image ansgar posted 10 years ago Permalink
There was a similar delay issue when connecting, reported here. I guess I fixed both of these by updating libmysql.dll

Please login to leave a reply, or register at first.