Is there a way to easily migrate from HSQL to MySQL in open fire? I’ve been asked to move the database back to MySQL and wasn’t sure how short of reinstalling OpenFire. There is no option to modify the database tab and when I edit the openfire.xml file manually it does not switch over? Assistance?
After you are done moving/copying the database data, stop OpenFire, and edit the openfire.xml file. Look for
<setup>true</setup>
. Change it to false, and start OpenFire and access the admin console. It will show you the setup again, so you can choose a new database.