- 1886 posts
- 387 comments
- very few titles
- tons of dead links
- terrible English
I have finally imported my old b2 archives, more than two years of short titleless (and often pointless, really) posts and dead links (where art thou, great backup of the intarweb?) from May 2000 to December 2002.
The backup .sql file had been sitting in a directory for years, and it was in my projects to import it back online ever since I resumed blogging on January 1st, 2004.
Tonight it only took me a grand total of two hours to upgrade the SQL schema (basically, run import-b2.php, ignore the many SQL errors, then run upgrade.php), sort out the possible ID conflicts (bumping post ids, comment ids up and so on), run test imports, debug the problems, test again and then do the import dance on the production database.
In the end while the real import was going on, I was biting whatever remained of my nails.
Trouble and all, but at least now all my posts are back online… This blog just turned five years and three months old!