sfiuser Posted March 20, 2007 Share Posted March 20, 2007 Hi, I am a newbie to MySql and am trying to import a dump file from a server running MySql 4.1.21 into a server running MySql 4.0.24. I guess there seems to be some sort of compatibility issue between the two versions. This is the error I get when I try to restore the dumpfile from the command line on the server running MySql 4.0.24: ERROR 1064 at line 12: 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 'DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci' at line I tried using mysqldump's --compatible=mysql40 option when you create the dump file but that generated the same error too. If anyone could point me in the right direction I would be very grateful. Thanks. Link to comment https://forums.phpfreaks.com/topic/43512-compatibility-issues-when-importing-into-diferent-versions-of-mysql/ Share on other sites More sharing options...
fenway Posted March 20, 2007 Share Posted March 20, 2007 It used to be default charset, not character set. Link to comment https://forums.phpfreaks.com/topic/43512-compatibility-issues-when-importing-into-diferent-versions-of-mysql/#findComment-211387 Share on other sites More sharing options...
sfiuser Posted March 20, 2007 Author Share Posted March 20, 2007 Thanks for the post but this dosent work either. How much more changed from each version ? Any other suggestions ? Thanks. Link to comment https://forums.phpfreaks.com/topic/43512-compatibility-issues-when-importing-into-diferent-versions-of-mysql/#findComment-211451 Share on other sites More sharing options...
fenway Posted March 21, 2007 Share Posted March 21, 2007 Well, that's one of the issues... post the entire create table; and check the docs for incompatible changes. Link to comment https://forums.phpfreaks.com/topic/43512-compatibility-issues-when-importing-into-diferent-versions-of-mysql/#findComment-212234 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.