mysty Posted January 4, 2007 Share Posted January 4, 2007 I am trying to move my mysql database from one hosting company to another. I have used SQLYog and I have used phpmyadmin to backup the database. When I try to import to the new host, I get an error that won't let me proceed. The error is something like:#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 'DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='InnoDB free: 1Any ideas what I need to do so that I can import this database? Quote Link to comment Share on other sites More sharing options...
fenway Posted January 5, 2007 Share Posted January 5, 2007 Depends which version you exported from & which you're importing into. Quote Link to comment Share on other sites More sharing options...
mysty Posted January 7, 2007 Author Share Posted January 7, 2007 I am going from MySQL 4.1.7 to MySQL 5.0.18I have pretty much decided that the database is not that large, so will just repopulate it by manually entering the data again. However, if anybody has a suggestion about how to fix this, I would still be curious. Quote Link to comment Share on other sites More sharing options...
fenway Posted January 7, 2007 Share Posted January 7, 2007 Well, I'm pretty sure that now CHARSET is CHARACTER_SET. 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.