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.
auto refresh, export
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
Please login to leave a reply, or register at first.