[otrs] How Should I Migrate the OTRS MYSQL Database?

[Nils Breunese (Lemonbit)]

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.