Hello,

don't want to bother again, but I'd like to switch to MySQL and did not figure it quite out.

I used db.properties.mysql from ./apps/antville/db_support and copied it to ./apps/antville/db.properties. This does not seem to cut the deal.

There is a script called antville_mysql.sql which creates the tables and user/pass in MySQL, how is this executed? Did I miss something?

Thank you!

If you just want to configure antville to use MySQL instead of Mckoi, here's the basic setup procedure:

1. Have a working installation of MySQL.
2. Make sure you have the MySQL JDBC driver installed. You can download the latest version from the MySQL web site. Place the driver .jar file into the lib/ext folder of your installation.
3. Import antville_mysql.sql. I think this can be done with

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

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

4. Copy db.properties.mysql to apps/antville/db.properties (like you did already) and adapt it to your actual setup (URL, user, password)

This should be it.

If you want to transfer existing date from Mckoi to MySQL, that could be a bit trickier. It may be possible with 3rd party JDBC tools. It may also be possible to do this using a low level Helma hack. Let me know if you need this and I may be able to provide something later today.