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.