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. Quote Link to comment 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. Quote Link to comment 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. Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.