I recently did an upgrade from 1.2.2 to 2.0.2 and simply using that script is not enough. I found several changes that did not get done, and I fixed those manually. The best way to approach this would be to compare the old schema with the new one and do all the changes, but check that update sql file as they do some table alterations in a special way (alter table, update data then alter again). The way I did it (not the best way) was to use the old database run the update script and use the web interface to weed out initial differences by clicking some links. Then I ran PostMasterPOP3.pl manually and found some bugs. I think we still have som table alterations to finnish off, but it works now. :) Best regards Are Hoel Systems Administrator Telio AS - www.telio.no

-----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Bryan Fullerton Sent: 20. september 2005 21:51 To: User questions and discussions about OTRS.org Subject: 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 _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? =http://www.otrs.de/