Support » Installing WordPress » Moving to new server

  • I’m trying to move my database to a new server, and everytime I go to restore it, I get this 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 ‘– phpMyAdmin SQL Dump
    — version 2.6.1-pl2

    I checked the sql file and there isn’t any of those characters before the dashes in the file, yet it insists they are there. Am I looking at the wrong thing altogether?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Mark (podz)


    Support Maven

    Are you opening the sql file in something like notepad ?
    You need a plain text-editor.

    Or, open the file and paste the sql in ?

    Yes I am opening it in notepad to do my editing (URL, email, etc).

    Open the file and paste the sql in where? Sorry, I really know very little about all of this.

    Okay, I opened it in editpad and resaved it, and now it worked.

    Mark (podz)


    Support Maven

    Try this:
    Copy the sql file. Keep the copy safe.

    Open the sql file
    after all the

    lines you will see either

    Delete everything above that.
    retry the import ?

    The import was successful, but now my site looks like this:

    And I cannot get logged in to make any sort of changes.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Moving to new server’ is closed to new replies.