Hi, I have been trying to export mySQL db from ipage and it comes out fine. Now this file when i try to import into mySQL db of Hostgator (using myphpadmin), i get the following error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'phpMyAdmin SQL Dump Can someone help me resolve this issue? I want to smoothly move between ipage server and hostgator server databases.
What versions of MySQL are being used on the respective servers? The error message will give you your clue. I cannot know exactly what is causing the error, but often in cases such as yours it is a simple syntax error that can be resolved by opening the SQL dump file in an editor and modifying it near the line that triggers the error message. If you post a few lines before and after the line given in the error message, that might provide more information.