Problem while Importing a database to phpmyadmin

Discussion in 'Content Management' started by raptormarketing, Feb 11, 2010.

0
  1. #1
    I have been facing a problem while importing database ( for a wordpress blog ).Whenever I try to replace and import new database in phpmyadmin,I get this error msg

    " #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 '"1"' at line 1"

    [​IMG]


    In order to solve this problem i search on Google,visited several sites and forums but unable able to find out exact solution.
     
    raptormarketing, Feb 11, 2010 IP
  2. titoni

    titoni Active Member

    Messages:
    965
    Likes Received:
    23
    Best Answers:
    0
    Trophy Points:
    58
    #2
    It means there has a SQL syntax in your database script. please post your database script.
     
    titoni, Feb 12, 2010 IP
  3. dotcomdude

    dotcomdude Active Member

    Messages:
    100
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    68
    #3
    These kind of errors can be tricky to pin down. I've known them be due to the use of a ' instead of a ".

    The pointer 'near '"1"' at line 1' is the place to start.

    You really would need to post that line of code for anyone to be able to help you further. Just make sure there's nothing too sensitive in the line that you post...
     
    dotcomdude, Feb 17, 2010 IP