Besides the single posts table, is there any significant difference between the two database schema I should be aware of?

The user table is pretty different mostly because of the way registration works. I'll need to do some custom work there anyhow to deal with using existing password hashes so that's not really a big deal. I think the bookmarks table carries a bit more data than the current one but that can be backfilled.

Just to note to other people reading this. Your passwords are not stored in the current database or the new database. So we're not passing around actual passwords at any point here, just hashes.

In the new board, you can't easily hotlink to a particular post, the way you can click on a post number over here.

Indeed. I'll fix that as soon as I get a chance. Thanks.

Fixed it.

Testing something:

smonster "Coffee On My Monitor Again" Sep 23, 2009 6:27:02 am PDT

Whatever you were testing, I hope it worked. And thank you for the lovely trip down memory lane. We've been funny people!

Looks like a missing feature for the new board.

So I just committed a perl script ('cause that's how I roll), that attempts to translate between the two databases, and clean up the data. The output is 210M compressed, which is smaller than I thought it would be.

As it is, it won't really work, because you define some fields to be non-NULL that don't exist in the old database.

So, anyway, take a look at the script. You could probably run it yourself, since mysql.buffistas.org doesn't seem to be firewalled. (I ran it several times during testing, so it wouldn't surprise me if we bump into some kind of provider database transfer limit, sorry!) Please check if the translation between the table names and field names looks OK, and anything else that you see needs to be fixed.

Cool. Thanks!