Home Web Development Magento database import error #1452
Magento database import error #1452 PDF Print E-mail
Written by Administrator   


If you get the following MySql error #1452 when importing an Magento database...



This is due to a foreign key constraint, but your whole database should be complete.

Run the following SQL query in the MySql query field:


SET foreign_key_checks = 0;

ALTER TABLE  `eticatalog_eav_attribute` ADD CONSTRAINT  `FK_ETICAT_EAV_ATTR_ATTR_ID_ETIEAV_ATTR_ATTR_ID` FOREIGN KEY (  `attribute_id` ) REFERENCES `etieav_attribute` (  `attribute_id` ) ON DELETE CASCADE ON UPDATE CASCADE ;

SET foreign_key_checks = 1;