Restoring Database

  • Resolved jessinsd

    (@jessinsd)


    19 years ago

    I’m switching hosts and I’m uploading my backup of my sql db to my new one and i keep getting this error:

    #1064 – You have an error in your SQL syntax near ‘ENGINE=MyISAM DEFAULT CHARSET=latin1 ‘ at line 14

    I really have no idea how to do this. Does anyone know how to handle this?

    Thanks in advance.

Viewing 2 replies - 1 through 2 (of 2 total)

  • yep – easily sorted ??

    Open the .sql file in a plain text-editor (not a wordprocessor)

    Do a search/replace, replacing
    DEFAULT CHARSET=latin1
    with nothing at all.

    Save, import ??

    Thread Starter jessinsd

    (@jessinsd)

    Thank you so much podz, I made it past line 14!

    I have a new error though and I’m not sure if I should delete this or not:

    #1064 – You have an error in your SQL syntax near ‘INSERT INTO wp_categories VALUES (1, ‘Uncategorized’, ‘uncategorized’, ”, 0, ‘ at line 20

    Thanks.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Restoring Database’ is closed to new replies.