Restoring Database Syntax Error

  • frank144

    (@frank144)


    20 years, 6 months ago

    Hi,

    I had already moved one blog from one server to another with no problem, but I encountered this problem when attempting to do it with another:

    # WordPress MySQL database backup

    DROP TABLE IF EXISTS plblog_categories

    MySQL said: 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 ‘# WordPress MySQL database backup DROP TABLE IF

    Basically, I used the WP backup plugin to make the sql file, created a new database in the server I wanted, and tried to run this. Any ideas? Thanks!

Viewing 1 replies (of 1 total)
  • Mark (podz)

    (@podz)

    20 years, 6 months ago

    #
    Those characters are breaking it.

    Open the .sql file with notepad++ or Notepad
    Remove those characters
    Resave the file
    Retry the import, and post back ?

Viewing 1 replies (of 1 total)

The topic ‘Restoring Database Syntax Error’ is closed to new replies.

Tags