auto refresh, export

BubikolRamios's profile image BubikolRamios posted 14 years ago in Import/Export Permalink
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.
ansgar's profile image ansgar posted 14 years ago Permalink
Which revision?
BubikolRamios's profile image BubikolRamios posted 14 years ago Permalink
I think all til including this one:5.0.0.3149

ansgar's profile image ansgar posted 14 years ago Permalink
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.
Code modification/commit from ansgar.becker, 14 years ago, revision 5.0Beta.0.3216
SQL exporter: Don't trust a cached TDBObject if a table says it has 0 rows. There may be rows inserted from outside since the database cache was filled. See http://www.heidisql.com/forum.php?t=5367
ansgar's profile image ansgar posted 14 years ago Permalink
Fixed in r3216
BubikolRamios's profile image BubikolRamios posted 14 years ago Permalink
thanks.

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