WordPress.org

Support

Support » Installation » Moving to new server

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
    http://www.ph

    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)
  • 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.

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

    Open the sql file
    after all the



    lines you will see either
    DROP TABLE IF EXISTS
    or
    CREATE TABLE

    Delete everything above that.
    Save
    retry the import ?

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

    so-faded.net

    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.
Skip to toolbar