Migrate HSQLDB to MySQL

Spark Spark Support
1

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…

Thanks.

2

Hi Jeffrey,

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

  [http://ralf.schaeftlein.de/2012/02/18/migrating-hsqldb-to-mysql/](http://ralf.schaeftlein.de/2012/02/18/migrating-hsqldb-to-mysql/)

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”.