I am trying to import(with bigdump) my live database to an test database. While importing the tables to the test database im getting the following error.
MySQL: Cannot add or update a child row: a foreign key constraint fails (DB_Name.catalog_product_entity, CONSTRAINT FK_CAT_PRD_ENTT_ATTR_SET_ID_EAV_ATTR_SET_ATTR_SET_ID FOREIGN KEY (attribute_set_id) REFERENCES eav_attribute_set (attribute_set_id) ON )
I have set the SET Foreign_Key_Checks
but it seems this isn't changing the error at all.
SET FOREIGN_KEY_CHECKS = 0;
//Code
SET FOREIGN_KEY_CHECKS = 1;
Do I need to change table names? What am I doing wrong?
Best Answer
I had the same problem. I ended importing my MySQL database dump using SSH.
This could be done like this:
This works for me and it is also much faster.