Migrate HSQLDB to MySQL

Openfire Openfire Support
1

Hello,

I am upgrading my OpenFire to the most recent version and I plan to start some clustering while I am at it. I want to move my database from HSQLDB into a MySQL database. My only problem is I have user accounts and passwords on the old one (at least that is where I assume they are stored) and I would like to avoid having to recreate all of the accounts. Is there a way to get all of my users onto my new server/database? If there is a utility or a walk through I would appreciate it.

Thank you,

-Welic

2

Hi Welic,

Take a look at the User Import Export plugin.

Cheers,

Ryan

3

I have a similar issue. I want to export the Gateway Registrations. The rest of the stuff is irrelevent as I use LDAP.

4

That did it, sorry for the noob question.