Embedded-db to mysql

Openfire Openfire Support
1

Hi,

is there a way, to import the embedded-db to a mysql db? I want to switch from embeddeddb to a mysql-db.

Any ideas?

2

Hi,

you could create the MySQL database and run then the embedded-db/openfire.script (without the create table and index statements) and embedded-db/openfire.log files within MySQL, maybe this works without adjustments. If errors are thrown they should be self-explaining - not all databases support “TEXT” the same way. You may get a problem with UTF-8 characters as HSQLDB stores them as unicode.

There is also the Export-/Import-Plugin - it should be fine if you need to migrate only the users.

LG

3

Thanx very much, I’ll try this.