powered by Jive Software

Migrate HSQLDB to MySQL

Good day!

I am new with Openfire and Spark, my problem is I want to migrate or change my default database which is HSQL Database Engine 1.8.0 to MySQL. Where can i locate the embedded database and how can i migrate the database as I mentioned?Can you give me some steps?

Please help…


Hi Jeffrey,

you may use the “MySQL Migration Toolkit” as mentioned over here


We used “Pentaho Data Integration” to migrate from MySQL to Prostgresql.

You will find the database in your openfire folder: “openfire\embedded-db\openfire.script”.