lional Posted July 16, 2006 Share Posted July 16, 2006 Hi AllI am getting this error #1064 - You have an error in your SQL syntax.I exported my database because I had to reload my machine, now when I want to import the data I get the following error. This happening with all of my databases.Please helpThanksLional Link to comment https://forums.phpfreaks.com/topic/14773-mysql-error/ Share on other sites More sharing options...
AndyB Posted July 16, 2006 Share Posted July 16, 2006 Please post the complete error message.Could be a version problem, a collation problem, a charset problem. Hard to tell without knowing the actual error message you get. Link to comment https://forums.phpfreaks.com/topic/14773-mysql-error/#findComment-58977 Share on other sites More sharing options...
lional Posted July 16, 2006 Author Share Posted July 16, 2006 #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 '\'deon\', \'gavin\', \'Room1\', \'Room2\', \'Room3\', \'Room4\' Link to comment https://forums.phpfreaks.com/topic/14773-mysql-error/#findComment-58978 Share on other sites More sharing options...
AndyB Posted July 16, 2006 Share Posted July 16, 2006 My guess is that all those escaped single quotes are the problem - possibly from the settings you chose when you exported the data. Link to comment https://forums.phpfreaks.com/topic/14773-mysql-error/#findComment-58996 Share on other sites More sharing options...
fenway Posted July 16, 2006 Share Posted July 16, 2006 Sounds like a reasonable assumption -- you can post the offending lines of the export? Link to comment https://forums.phpfreaks.com/topic/14773-mysql-error/#findComment-59016 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.