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? Link to comment https://forums.phpfreaks.com/topic/32905-mysql-error-when-exportingexporting/ 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. Link to comment https://forums.phpfreaks.com/topic/32905-mysql-error-when-exportingexporting/#findComment-153289 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. Link to comment https://forums.phpfreaks.com/topic/32905-mysql-error-when-exportingexporting/#findComment-154959 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. Link to comment https://forums.phpfreaks.com/topic/32905-mysql-error-when-exportingexporting/#findComment-155006 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.