| 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
|
|
|
