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

kalvaro's profile image kalvaro posted 9 years ago in Import/Export Permalink
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, 9 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, 9 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
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.
ansgar's profile image ansgar posted 9 years ago Permalink
Agree. Both done in r3708 and r3709.
kalvaro's profile image kalvaro posted 9 years ago Permalink
Lovely, thanks. Sometimes these little things make a big difference :)

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