I have been using Blosxom for a number of years for blog presentation. Long ago, it became unsupported, simply for the fact that managing a large number of text files is not scalable. Hence the reason why blogging software has long embraced the database solution. I have reached and exceeded the scalability limits of Blosxom and have now embraced the database solution offered by Serendipity. My biggest reason for choosing that solution was its use of PostgreSQL as the back end database. I prefer PostgreSQL over MySQL. Ok, there is my bias showing.
Prior to selecting Serendipity, I flirted briefly with Movable Type. They, however, were going the MySQL route and deprecating the PostgreSQL side of things. As part of my testing of Movable Type, I wrote a Perl script to take my Blosxom files, package them together, and make in import file into Movable Type.
After having gone through that exercise, and then finally selecting Serendipity, it was nice to know that Serendipity knows how to import the basic Movable Type import file. The Serendipity import process doesn't appear to know how to deal with the categories, so I am in the process of updating those manually.
In addition, new entries are set as 'IsDraft', so I needed to run a database query afterwards to actually 'publish' the entries. I suppose a better process would have been to manually edit the entries, set the categories, and then 'publish'. But with over 500 entries, that type of process was a bit daunting, so, instead, I published all the migrated entries, and I'll update categories as time passes.
The Perl script for creating the import file: Continue reading "Blog Migration From Blosxom To Serendipity" »