Migrating openfire install to new server

Hello there!

I tried searching all discussions on this topic but I’ve come up with naught.

Either way, here is my problem.

I have an openfire install, version 3.6.1 on centos 5.2 currently running on a server. It is using the built in stock database and is running perfectly.

However, due to the limited amount of RAM on this system, the VM usage is peaking very high throughout the day during it’s usage and I would like to move it to a more powerful server which has already been set up. Also, this would be ideal as our user base is growing.

So here is what I would like to do:

Move the current install of openfire to the new server (tar it up and transfer the entire install directory?)

Upgrade to version 3.6.3 of openfire - I get how to do this with the RPM’s thanks to the docs but I would like to…

…migrate the built in database to MySQL.

Any tips or advice would be more than helpful

Thank you very much!

Hi,

search for “mysql migration”? The search index was broken, so you may have found nothing.

You may also want to read and update http://www.igniterealtime.org/community/docs/DOC-1540

LG

View

http://www.igniterealtime.org/community/docs/DOC-1994

Hello, I’ve just done the same thing.

my DB is mysql so follow my procedure

on old machine type: mysqldump -u username -ppassword database_name > FILE.sql

on new machine

create a new BD with the same name that was in the old machine

stop the openfire

import the DB

mysql -u username -ppassword database_name < FILE.sql

copy the ~/openfire whole to the new machine

start openfire