homepage Welcome to WebmasterWorld Guest from 54.161.200.144
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
Magento DB movement issue error
fRAiLtY




msg:4085068
 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




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

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

dreamcatcher




msg:4085443
 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