Buice, David R wrote:
I need to migrate our existing OTRS database (version 1.2.3!) which currently resides on a Linux box onto a Solaris server which has OTRS 2.2.4 installed.
I was thinking that perhaps I would do a backup on the Linux server and then a restore on the Solaris server... But I thought I should first consult with you fine people before I do something potentially stupid or dangerous.
As long as you have the old working server (and backups!) you should be OK.
I'm running Apache and MYSQL on the Solaris server. It would be nice to somehow retain the myriad configurations that were done on the Linux machine thereby not having to re-create the wheel, but perhaps that's asking too much.
Any and all recommendations would be gratefully accepted.
1) Dump the database on the old server, import it on the new one and the run all the applicable database upgrade scripts to upgrade the database to 2.2 step by step. In your case that would be DBUpdate- to-1.3.mysql.sql, DBUpdate-to-2.0.mysql.sql, DBUpdate- to-2.1.mysql.sql, DBUpdate-to-2.2.mysql.sql, DBUpdate-to-2.2.2.sql. These scripts can be found in the scripts directory. 2) If you want to migrate the configuration settings as well you're not asking too much. See '5.12. The graphical configuration frontend (SysConfig)' in the docs which mentions that you backup and upload settings: http://doc.otrs.org/2.2/en/html/x1033.html Nils Breunese.