mysql - 如何成功导出 Magento 1.9 数据库(MySQL 5.6)并将其导入 MySQL 5.5

Question

我已转储 MySQL (5.6.40 - MySQL Community Server (GPL)) 数据库 (Magento 1.9) 并尝试将其导入 MySQL (5.5.55-38.8-log - Percona Server (GPL)，版本 38.8 ，修订版11f5bbd)，在导入过程中，大多数脚本都会正常执行，但其中一些会失败，如下所示:

10:48:04    
ALTER TABLE `affiliateplusprogram_category`   
ADD CONSTRAINT `affiliateplusprogram_category_ibfk_1` FOREIGN KEY 
(`program_id`) REFERENCES `affiliateplusprogram` (`program_id`) ON DELETE 
CASCADE ON UPDATE CASCADE,   ADD CONSTRAINT 
`affiliateplusprogram_category_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES 
`catalog_category_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,   
ADD CONSTRAINT `affiliateplusprogram_category_ibfk_3` FOREIGN KEY (`store_id`) 
REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE

Error Code: 1452. Cannot add or update a child row: a foreign key constraint fails (dailynuc_dailynu.#sql-1466_121c50b, CONSTRAINT affiliateplusprogram_category_ibfk_2 FOREIGN KEY (category_id) REFERENCES catalog_category_entity (entity_id) ON DELETE CASCADE ON UP) 0.015 sec

请指导我如何正确执行此操作，非常感谢您的帮助!

Answer 1

只需使用

禁用 key 检查

SET FOREIGN_KEY_CHECKS=0;

位于 sql 转储的顶部。

迁移完成后也将其重新打开

SET FOREIGN_KEY_CHECKS=1;