Export reports wrong number of rows

[expired user #8841]'s profile image [expired user #8841] posted 8 years ago in Import/Export Permalink

Hi there,

I did a database export today and the file contains

-- Dumping data for table d019d8c3.contactform: ~0 rows (approximately)
/*!40000 ALTER TABLE `contactform` DISABLE KEYS */;
INSERT INTO `contactform` (`ID`, `name`, `description`) VALUES
    (1, 'Kontaktformular', 'Kontaktformular');

As you can see, there is one row returned but the comment says approx 0 rows.

The last export was done with 8.3.0.4750 and it worked there, so I guess it's a bug.

So lonG

ansgar's profile image ansgar posted 8 years ago Permalink

That 0 rows (approximately) is intentionally, and due to the InnoDB table engine which reports an approximated row count. Nothing HeidiSQL can fix.

See the wrong numbers yourself when you fire a SHOW TABLE STATUS

[expired user #8841]'s profile image [expired user #8841] posted 8 years ago Permalink

ok thx

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