Magento

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:

SQL-Befehl:

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.

Christoph

Hello.., just create a dump file straight from MySql database, and then restore it in another server.

add this to your sql file:

Or when you export, enable the option Disable foreign key checks

Hi
i am having the same error as you got Christoph

now i have changed the
SET FOREIGN_KEY_CHECKS = 0

now i am having this error