第1215行出现错误1215 (HY000)：无法添加外键约束

Question

当我尝试导入数据库转储时，我收到"ERROR 1215 (HY000) at line 966: Cannot add foreign key constraint“错误。下面是966行：

CREATE TABLE `CATEGORIE_tags` (
      `categorie_id` int(11) NOT NULL,
      `tag_id` int(11) NOT NULL,
      `id` bigint(20) NOT NULL AUTO_INCREMENT,
      `flag` tinyint(1) NOT NULL DEFAULT '0',
      `tags_id` bigint(20) DEFAULT NULL,
      PRIMARY KEY (`id`),
      KEY `tag_id` (`tag_id`),
      KEY `categorie_id` (`categorie_id`),
      KEY `FKACB212415C86F159` (`categorie_id`),
      KEY `FKACB21241925C59A` (`tag_id`),
      CONSTRAINT `CATEGORIE_tags_ibfk_1` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`),
      CONSTRAINT `CATEGORIE_tags_ibfk_2` FOREIGN KEY (`categorie_id`) REFERENCES `CATEGORIE` (`CAT_ID`),
      CONSTRAINT `FKACB212415C86F159` FOREIGN KEY (`categorie_id`) REFERENCES `CATEGORIE` (`CAT_ID`),
      CONSTRAINT `FKACB21241925C59A` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=1331 DEFAULT CHARSET=utf8;
    /*!40101 SET character_set_client = @saved_cs_client */;

你知道为什么吗？谢谢

Answer 1

如果以错误的顺序导入表，约束检查将失败。

示例:在标记表之前创建Category_tags表，并且Category_tags引用标记。

Fix:导入时禁用外键检查。

SET FOREIGN_KEY_CHECKS = 0;

--  / import dump code here / 

SET FOREIGN_KEY_CHECKS = 1;  

http://www.stetsenko.net/2008/10/mysql-how-to-ignore-checking-of-foreign-key-constraints-for-innodb-tables/