zengun

weblog

20050820

1886

  • 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!


one response

  1. [...] Non, non, je démends toute inspiration provenue de l’initiative de Michel (ou pas) ! [...]

    #1 BeerTech… as in “beer”. » Blog Archive » Message technique2005/08/20 at 10:33

Your words


Required fields:
Are marked by this sign: *
XHTML:
You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>
On comment spam/irrelevance:
Your comment may be moderated or considered as spam by the leprechauns running this server. If you get a 412 error or a mean message, it may be that they thought it was spam: try wording the comment differently or remind me to put up a contact form so you can warn me about the problem.
Of course, once the leprechauns are done doing their magic, I reserve the right to delete any comment for any reason.