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

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




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.