I am hopeing this is migrated accurately, here are the steps I took. Please let me know if you see something I missed.
On the OLD system; (with Openfire running)
mysqldump -h liger --opt openfire -p > db_dump.sql
SCP’d db_dump.sql over to the NEW system.
scp db_dump.sql username@servername:/tmp/db_dump.sql
On the NEW system, I did the following;
/etc/init.d/openfire stop
mysqladmin drop openfire
mysqladmin create openfire
at this point I have a blank database and I import the OLD systems exported database into the NEW systems database;
mysql -p -h viryeschap01 openfire < /tmp/db_dump.sql
mysql -e grant all privileges on openfire.* to ofuser@hostname identified by ‘password’
mysql -e “flush privileges”
Start Openfire and check for errors.
tail -f /opt/openfire/logs/error.log
/etc/init.d/openfire start
Now I launch the webbrowser and start the Openfire configuration steps;
[http://10.1.1.1:9090/index.jsp](http://10.1.1.1:9090/index.jsp)
Once complete, I launch Spark and point it to the NEW server. I log in and see my buddy lists, and conference rooms, etc. They complain because they are looking for the production VIP and not the test one I have in place. Otherwise it looks good from the Spark point of vew. I can chat with others who are testing, tho we are not able to see eachother as online unless we send a new invite, it appears to be working as expected.
Here are a couple of questions.
-
Do the above steps look correct?
-
Should I be concerned with the mysql DB table differences between the old and new versions?
-
Same as the above, but for the Schema?
My fear is the jump from 3.5.2 too 3.6.4 there were some table/schema changes to the mysql DB and those may have not been converted with the process I used above.
Thanks everyone for your feedback, its been really beneficial to getting this rolled out properly.
Maurice