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 Quote Link to comment 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. Quote Link to comment 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\' Quote Link to comment 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. Quote Link to comment 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? 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.