Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

Magento DB movement issue error

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

New User

5+ Year Member

joined:Feb 22, 2010
posts: 2
votes: 0

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)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Dec 15, 2003
votes: 0

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

Senior Member

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

joined:Mar 30, 2003
votes: 0

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


Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members