Jump to content

Archived

This topic is now archived and is closed to further replies.

lional

MySQL error

Recommended Posts

Hi All

I 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 help

Thanks
Lional

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
#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\'

Share this post


Link to post
Share on other sites
My guess is that all those escaped single quotes are the problem - possibly from the settings you chose when you exported the data.

Share this post


Link to post
Share on other sites
Sounds like a reasonable assumption -- you can post the offending lines of the export?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.