distal-attribute
distal-attribute
distal-attribute
distal-attribute

auto refresh, export

User, date Message
Written by BubikolRamios
4 years ago
Category: Import/Export
327 posts since Thu, 14 Jan 10
1.have opeded heidi sql and mysql query browser
2. delete * from table x (mysql query browser),import into table x (heidi sql), editing data in table x (mysql query browser)
3. export with heidi sql data from TABLE x
4. structure exported but no data ! Data are there in table doh.
5. I guess refresh would help, tested with switch back and forward with session manager and then it worked.
Written by ansgar
4 years ago
4987 posts since Fri, 07 Apr 06
Which revision?
Written by BubikolRamios
4 years ago
327 posts since Thu, 14 Jan 10
I think all til including this one:5.0.0.3149

Written by ansgar
4 years ago
4987 posts since Fri, 07 Apr 06
Oh, yes you detected a minor caching problem: SHOW TABLE STATUS result is cached and only refreshed when explicitely refreshed with F5, or by deleting tables. Now, if the cache says there are zero rows, and some rows get inserted from outside (anyway if it's Heidi or some other client), Heidi just exports a comment saying "No rows for table xyz". Will check that.
Written by ansgar
4 years ago
4987 posts since Fri, 07 Apr 06
Fixed in r3216
Written by BubikolRamios
4 years ago
327 posts since Thu, 14 Jan 10
thanks.
 

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