I use the Manual-Transfer from http://community.igniterealtime.org/docs/DOC-1540
I setup an “new” Openfire System with an Connection to MySQL and stop Openfire.
The Connection to the Database and via the Admin-Console works fine.
Then I use a copy of the openfire.script file.
In this new file, I changes the Column-Names to the MySQL-Schema (Upper/Lower-Cases) and import the Data into the MySQL-Database via the Import-Function of PHPmyAdmin.
After restart of Openfire, I could connect via the Admin-Console to Openfie.
I can’t connect into Openfire via Spark with the old Password.
After I changed my Spark-Password via the Admin-Console, I am able to connect.
But with over 390 Users, I can’t change the Password for all of them.
So I swichted back zu the embeded DB.
I tried the “Import-Export-User” Plugin, but when I whant to export the Useres onto the screen, I get only an “empty” Page.
My system is a virtual Debian-Lenny