Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Export database and row count

959 posts

kalvaro posted 12 years ago in Import/Export

I have an InnoDB table where the system reports 1531 rows instead of the actual figure, 1327. So far so good: we all know that SHOW TABLE STATUS returns an approximation, not the real number.

The funny thing is that I used Heidi's "Export database as SQL" feature and the report grid displayed 1531 / 100%.

(BTW, it'd also be nice that stored routines would not display a -1 row count.)

Given that's a report of a very specific operation, wouldn't it make more sense to give the exact number? I suppose it could be obtained from the either the SELECT * metadata or an internal counter.

Code modification/commit from ansgar.becker, 12 years ago, revision 3708

Display the real row count at the end of exporting table data, using an internal counter, to enhance accuracy. See http://www.heidisql.com/forum.php?t=7895

Code modification/commit from ansgar.becker, 12 years ago, revision 3709

Display nothing instead of "-1" for processed rows in case of non-tables. See http://www.heidisql.com/forum.php?t=7895

9832 posts

ansgar posted 12 years ago

Agree. Both done in r3708 and r3709.

959 posts

kalvaro posted 12 years ago

Lovely, thanks. Sometimes these little things make a big difference :)

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