Forum Moderators: open

Message Too Old, No Replies

Magento DB movement issue error

         

fRAiLtY

9:44 pm on Feb 22, 2010 (gmt 0)

10+ Year Member



Hi guys, first post!

I'm trying to move a live production money-taking site to another server, it's a magento store. I moved all the files and images across no problem, but can't upload the phpmyadmin dump SQL file back through the other servers phpmyadmin. I keep getting #1052 foreign key constraint errors? There's nothing wrong with the database as I even tried it on a fresh magento database with the same errors.

It seems the working phpmyadmin dump doesn't work when loaded back through itself and I can't figure out why?

Any ideas please!?

Demaestro

9:54 pm on Feb 22, 2010 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



Is the version of the new MySQL the same version as the original MySQL?

dreamcatcher

9:12 am on Feb 23, 2010 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Have you tried some of the compatibility modes when exporting? Try exporting for MySQL 4.

dc