I'm doing tests to change a current table from my InnoDB database to Archive, but I had a problem trying to restore a dump after the change.
After several tests, the problem is related to the value declared in the AUTO_INCREMENT attribute in CREATE TABLE. But this script is created automatically.
How can I fix this error so that I can restore the dump quickly without having to change it?
... -- -- Table structure for table `tabela` -- DROP TABLE IF EXISTS `tabela`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tabela` ( `cd_tabela` int(11) NOT NULL AUTO_INCREMENT, ... PRIMARY KEY (`tabela`) ) ENGINE=ARCHIVE AUTO_INCREMENT=3081487 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tabela` -- LOCK TABLES `tabela` WRITE; /*!40000 ALTER TABLE `tabela` DISABLE KEYS */; INSERT INTO `tabela` VALUES (1,...), ... (in this line the error appears) ...