Export database and row count

959 posts
kalvaro's profile image kalvaro posted 13 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, 13 years ago, revision 6.0.0.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, 13 years ago, revision 6.0.0.3709
Display nothing instead of "-1" for processed rows in case of non-tables. See http://www.heidisql.com/forum.php?t=7895
10138 posts
ansgar's profile image ansgar posted 13 years ago Permalink
Agree. Both done in r3708 and r3709.
959 posts
kalvaro's profile image kalvaro posted 13 years ago Permalink
Lovely, thanks. Sometimes these little things make a big difference :)

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