homepage Welcome to WebmasterWorld Guest from 54.166.84.82
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Magento DB movement issue error
fRAiLtY



 
Msg#: 4085066 posted 9:44 pm on Feb 22, 2010 (gmt 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!?

 

Demaestro

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



 
Msg#: 4085066 posted 9:54 pm on Feb 22, 2010 (gmt 0)

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

dreamcatcher

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



 
Msg#: 4085066 posted 9:12 am on Feb 23, 2010 (gmt 0)

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

dc

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved