So here's a simple Antville DB export script as promised yesterday. It lets you export existing Antville data from one database (say, the embedded Mckoi database in Antclick) to another (say, MySQL).

Here are the steps to take. I assume that you'll be migrating from Antclick/Mckoi to Mysql, but with a few changes it will work in any direction.

1. Update your installation of Antville to Helma 1.2.4 by downloading helma.jar and saving it to the lib directory of your antville installation (make a backup copy of the old version before)
2. Make sure you have a database driver for the new database you want to use. If it is MySQL, you can download the JDBC driver from the MySQL web site. Place the driver .jar file into the lib/ext folder of your installation.
3. Set up MySQL and import antville_mysql.sql, which you should find zipped up inside apps/antville/db_support.zip. This can be done with

   mysql -u root -p < /path/to/antville_mysql.sql

   You should be prompted for the mysql root password. You might want to change the antville user password (IDENTIFIED BY 'antville') in the GRANT statement at the beginning of the file before performing this step!

4. Open file apps/antville/db.properties in your favorite text editor and add the definition for the new database with the name antville-new:

   # Properties of antville datasource antville.url=jdbc:mckoi:local://./db.conf antville.driver=com.mckoi.JDBCDriver antville.user=admin antville.password=entwil

   antville-new.url=jdbc:mysql://localhost/antville antville-new.driver=org.gjt.mm.mysql.Driver antville-new.user=antville antville-new.password=antville

   Note that you might need to change the last line (antville-new.password=xxx) if you changed the password in step 3. The jdbc:mysql: URL may also look slightly different depending on your setup.

5. Download the following file and save it as apps/antville/root/export.hac

   export (application/octet-stream, 2 KB)

6. Start up Antville, open your browser and point it to http://localhost:8080/export (with http://localhost:8080/ being the home page of your Antville installation). If you get a page with many yellow lines and no mention of the word "error", you're 90% done.
7. Stop Antville and open file apps/antville/db.properties again. This time, you remove the original lines and change the lines you added in step 4 from "antville-new" to "antville":

   antville.url=jdbc:mysql://localhost/antville antville.driver=org.gjt.mm.mysql.Driver antville.user=antville antville.password=antville

The next time you start Antville, you should be running with your new database. If not, something went wrong. In any case, I'd be curious to hear.