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&Category... 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
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
From: Emily Flynn
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."
Hi, On 09.09.2009, at 18:46, Emily Flynn wrote:
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&Category...
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?
Windows? -- Shawn Beasley shawn@otrs.org Computers make work that one would not have without them go faster!
participants (3)
-
Emily Flynn -
MMoj＠timocom.com -
Shawn Beasley