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;
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
Now I launch the webbrowser and start the Openfire configuration steps;
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.