lots of problems with restoring database to new host

  • I am in the process of moving my blog from one host to another. The domain will be the same. I backed up my database on my old host per instructions using phpMyAdmin 2.6.4-pl2. I am now trying to restore my old database onto the new one at my new host, using phpMyAdmin 2.6.4-pl3. The problem is that it keeps throwing me out error after error.

    I already deleted the ‘latin1’ instances (a common trip-up), but now I am finding ‘closed quote’ errors and SQL parse errors all over the place and they are hard to trace. I even ended up having to delete some comments (spam comments) because something about their syntax was tripping up the code when it was run on the database.

    So I’m wondering if 1) I’m going to have to do this line by line, or 2) there is a larger problem here.

    Anyone have any insight? Thanks very much.

Viewing 1 replies (of 1 total)
  • Thread Starter sk4sk4

    (@sk4sk4)

    figured it out. i was trying to upload it to an older version of mysql. i created a backup copy using the MYSQL40 option in SQL Export Compatibility. Someone should throw a warning into the codex instructions for this detail.

Viewing 1 replies (of 1 total)
  • The topic ‘lots of problems with restoring database to new host’ is closed to new replies.