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?