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.

Sounds very clear to me - thank you very much for your work.

I however have problems to start antville with mysql in the first place. I wanted to try antville (antclick-1.0) with mysql as a "warmup" on a test server before I would tackle the conversion.

This is what I did:

I created the database within mysql using your script. Everything worked fine, 'mysqlshow' shows that the database was flawlessly created.

I changed apps/antville/db.properties:

myDataSource.url = jdbc:mysql://192.168.0.5/antville myDataSource.driver = org.gjt.mm.mysql.Driver myDataSource.user = antville myDataSource.password = xxx

(I changed the password in your database creation script before).

Then I copied mysql-2.0.14.jar to lib/ext and removed mckoi.jar there.

hop.sh was adjusted to local parameters and worked fine with mckoi before.

however, when I started antville and connected to it with a browser, it greets me with the following error:

Error in application 'antville':

Error retrieving Node: java.sql.SQLException: Datasource is not defined: antville.

I guess it must be my fault, but what is wrong?

my installation is under /opt/antville, if this is of any concern.

Thank you...