Hiya,

Sorry I'm doing this on an XP box just to test the upgrade process... prod box is on Windows Server 2003.

I am using MySQL Query Browser to run these scripts, I log into it using root, and then I can browse to the actual SQL script to run that and that is ok...

But as far as the Perl script goes, I don't know what to do with that as MySQL Query Browser won't run Perl... and I have no Perl experience so am really not sure how to go about it!

On a side... below where you write source $HOME_OTRS/scripts/DBUpdate-to-2.4.mysql.sql; do you mean me to paste that directly into the browser or do I amend $HOME_OTRS to the actual path, and if so, what it the best way to write this, i.e, the 'program files' bit?

Apologies for my silly questions and thanks.

Emily





MMoj@timocom.com
Sent by: otrs-bounces@otrs.org

09/09/2009 17:55
Please respond to
"User questions and discussions about OTRS." <otrs@otrs.org>
To
"User questions and discussions about OTRS." <otrs@otrs.org>
cc
Subject
Re: [otrs] perl migration script help





Hey,

just login into your mysql as 'root' and then do the following.

use otrs;

source $HOME_OTRS/scripts/DBUpdate-to-2.4.mysql.sql;

source $HOME_OTRS/scripts/DBUpdate-to-2.4.pl;
Here you´ll get some error´s just ignore them and go on with the following command.

source $HOME_OTRS/scripts/DBUpdate-to-2.4-post.mysql.sql;

Then you can quit from mysql and restart the services. Now just login into your OTRS System with an administrators account, go to the Admin panel and click on the sysconfig.

Have fun ;)

Mit freundlichen Grüßen / Kind regards
Markus Moj
IT Infrastructure & Services

TimoCom Soft- und Hardware GmbH
In der Steele 2
D-40599 Düsseldorf
Tel: +49 211 88 26 80 14
Fax: +49 211 88 26 70 14
eMail: MMoj@TimoCom.com
www.TimoCom.com
Geschäftsführer: Jens Thiermann, Gunther Matzaitis
Amtsgericht Düsseldorf, HRB 34489

Inactive hide details for Emily Flynn ---09.09.2009 18:48:07---Hello! I am trying to upgrade from 2.3.4 to 2.4.3, and I'm a bitEmily Flynn ---09.09.2009 18:48:07---Hello! I am trying to upgrade from 2.3.4 to 2.4.3, and I'm a bit lost on what to

From:
Emily Flynn <emily.flynn@zurichbank.com>

To:
otrs@otrs.org

Date:
09.09.2009 18:48

Subject:
[otrs] perl migration script help

Sent by:
otrs-bounces@otrs.org





Hello!

I am trying to upgrade from 2.3.4 to 2.4.3, and I'm a bit lost on what to do for running the perl migration script

http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&Subaction=Print&CategoryID=5&ItemID=351

I have MySQL Tools installed and so have used MySQL Admin to backup and restore, and MySQL Query Browser to run the first upgrade script (DBUpdate-to-2.4.mysql.sql ). I am not sure how to run the Perl migration script, can someone please give me a couple of pointers?

Thanks in advance

Emily---------------------------------------------------------------------
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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/
---------------------------------------------------------------------
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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/