1 Topic by rexron (edited by rexron 2009-08-06 09:39)

  • Registered: 2007-10-02
  • Posts: 18

Topic: DB problem

Hello.

I managed to delete my database  today (don´t ask). But I have a backupfile of it so it should not be a problem.
However when I do the SQL Query I get the following message:

#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 'DROP TABLE IF EXISTS `categories`' at line 12

Please help anyone

Sincerely
RexRon

  • Registered: 2007-09-27
  • Posts: 32

Re: DB problem

Which MySql version have you got installed? If your version is less than 3.22, that is exactly the error you would get, because the keywords "IF EXISTS" are used starting with the version 3.22.