Jump to content


Photo

MySQL error


  • Please log in to reply
4 replies to this topic

#1 lional

lional
  • Members
  • PipPipPip
  • Advanced Member
  • 266 posts

Posted 16 July 2006 - 03:36 PM

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

#2 AndyB

AndyB
  • Staff Alumni
  • Advanced Member
  • 5,465 posts
  • LocationToronto

Posted 16 July 2006 - 03:43 PM

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.
Legend has it that reading the manual never killed anyone.
My site

#3 lional

lional
  • Members
  • PipPipPip
  • Advanced Member
  • 266 posts

Posted 16 July 2006 - 03:45 PM

#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\'

#4 AndyB

AndyB
  • Staff Alumni
  • Advanced Member
  • 5,465 posts
  • LocationToronto

Posted 16 July 2006 - 04:36 PM

My guess is that all those escaped single quotes are the problem - possibly from the settings you chose when you exported the data.
Legend has it that reading the manual never killed anyone.
My site

#5 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 16 July 2006 - 05:33 PM

Sounds like a reasonable assumption -- you can post the offending lines of the export?
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users