Database restoration between versions?

Have you tried running wp-admin/upgrade.php?

Yes, I did. I kinda thought that was the problem. The backup database is from 2.0 and the install at the new location is 2.0.4.

The new location’s database won’t accept the old data without reporting either “syntax” errors or “sql” errors.

I’m considering repointing the domain back to the old site and attemting to import via rss if all else fails, but the tables at least appear to be the same, and in the same order. I don’t really see what’s wrong.

* shrug *

If the new wp is brand new a.k.a an empty blog, then start off with version 2.0, restore the backup, then upgrade.

If you can’t start off with version 2.0 on the new location, then restore the backup on wp 2.0 somewhere else (there’s always local server option), upgrade, back up, and restore on new location.

I’ll try upgrading the old site.

* fingers crossed *

It worked.

Here’s what I did:

In phpmyadmin:
I dropped the tables created previously.

replaced the schema from the backup.

then added the content one section at a time by opening the document, selecting the content (avoiding all commands apart from insert into and what follows. clicked on sql in the topmost menu of phpmyadmin, and pasted the clipboard into the input field. clicked go.

For whatever reason this avoided sql error and permission issues and worked.

Once all the data was back in, I repaired the database, and then ran the upgrade.php

All is well.

Thanks!