Hi to all,
I am trying to make a copy of my magento store 1.5.1.
I was using the function in the magento backend to export the database.
Then I was creating a new database at all-inkl. and then starting importing the database.sql.gz file with phpmyadmin.
It starting working and stopped maybe two times cause of timed out, but says I could resume and it was working so far.
Then I go this error:
ALTER TABLE `catalog_eav_attribute` ADD CONSTRAINT `FK_CATALOG_EAV_ATTRIBUTE_ID` FOREIGN KEY ( `attribute_id` ) REFERENCES `eav_attribute` ( `attribute_id` ) ON DELETE CASCADE ON UPDATE CASCADE ;
MySQL meldet: Dokumentation
#1452 - Cannot add or update a child row: a foreign key constraint fails (`d0135016`.<result 2 when explaining filename ‘#sql-910_3e334c’>, CONSTRAINT `FK_CATALOG_EAV_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CA)
Anybody an idea how this problem can be solved. I found many threads with similar post but not really a solution.
Or shall I use another way to copy the database into a new one?
What is the best way?
I just want to make a backup shop for testing!
Thy a lot in advance for any help.