Welcome to WebmasterWorld Guest from 54.205.209.95

Forum Moderators: open

Message Too Old, No Replies

Magento DB movement issue error

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

5+ 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!?
9:54 pm on Feb 22, 2010 (gmt 0)

WebmasterWorld Senior Member demaestro is a WebmasterWorld Top Contributor of All Time 10+ Year Member



Is the version of the new MySQL the same version as the original MySQL?
9:12 am on Feb 23, 2010 (gmt 0)

WebmasterWorld Senior Member dreamcatcher is a WebmasterWorld Top Contributor of All Time 10+ Year Member



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

dc