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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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/ > > _______________________________________________ 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/
