For quite some time, I used Apache Roller (version 4) as my weblog software. At first, I wanted to upgrade to version 5, but then, on second thought, dismissed the intention. Instead, I migrated to WordPress. The transition was not easy - probably because I missed some helpful tools. I ran Roller in a Tomcat 6 servlet engine and used Derby as the RDBMS backend. Here's an outline of the steps that were needed to migrate:
- Create a MySQL database.
- Install the MySQL JDBC JAR file and make sure Tomcat can find it.
- Shutdown the Roller webapp.
- Adapt roller-custom.properties to use the MySQL rather than the Derby database.
- Restart Tomcat (and thereby the Roller webapp).
- Access the Roller webapp and initiate the SQL scheme creation.
- Shutdown the Roller webapp.
- Start a standalone Derby server with the Roller database.
- Install openDBcopy, the MySQL JDBC JAR file and the Derby JAR files derbyclient.jar and derbytools.jar.
- Start openDBcopy and copy the Derby database to the MySQL database.
- Follow these instructions.
If someone's interested in detailed instructions, I'm willing to post them here.