When importing dumped data produced by HeidiSQL export feature I get the following error:
Note (Code 1031): Storage engine InnoDB of the table xxxxxx does not have this option
This is data for table HeidiSQL exported:
-- Dumping structure for table recall_qa.agency_types
CREATE TABLE IF NOT EXISTS `agency_types` (
`agency_id` int(11) NOT NULL AUTO_INCREMENT,
`description` varchar(50) DEFAULT NULL,
PRIMARY KEY (`agency_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
-- Dumping data for table recall_qa.agency_types: ~8 rows (approximately)
/*!40000 ALTER TABLE `agency_types` DISABLE KEYS */;
INSERT INTO `agency_types` (`agency_id`, `description`) VALUES
(0, ''),
(1, 'FDA'),
(2, 'USDA'),
(3, 'EPA'),
(4, 'US Consumer Product Safety Commission'),
(5, 'Other'),
(6, 'None'),
(7, 'CFIA');
/*!40000 ALTER TABLE `agency_types` ENABLE KEYS */