Re: [otrs] Migrating from OTRS 1 to OTRS2

On 9/20/05, Braun Brelin wrote:

Is there a preferred method for migrating the MySQL db to the new instance of OTRS?

Yes, it is preferred that you read the UPGRADING file in the OTRS package, which was specifically written to assist with upgrading from 1.3 to 2.x (if you're upgrading from 1.2 or earlier there will be other steps required). It includes: ===== *) Update the database changes with: MySQL: cat $OTRS_HOME/scripts/DBUpdate-to-2.0.mysql.sql | mysql -p -f -u root otrs PostgreSQL: cat $OTRS_HOME/scripts/DBUpdate-to-2.0.postgresql.sql | psql otrs ===== Change the mysql command line options as required for your setup. Bryan