Moving to new server

  • nicoleross

    (@nicoleross)


    19 years ago

    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
    — https://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 ?

    Thread Starter nicoleross

    (@nicoleross)

    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.

    Thread Starter nicoleross

    (@nicoleross)

    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 ?

    Thread Starter nicoleross

    (@nicoleross)

    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.