[rt-users] migrating mysql rt-3.6.3 db to new instance rt-3.8.8

[o.nash at cs.ucc.ie]

Hi all,
need advice on migrating to newer rt version.
I built rt-3.8.8 on a new server [ubuntu 10.0.4 with perl 5.10 ]
All went ok
got rt at a glance page up fine.

Then I took a dump of rt3 database from our running instance rt-3.6.3.
loaded this into the new rt3 database
did the upgrade [from the src tree dir] :
/opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password 
--action upgrade

But apache fails to start after this.
With this error:
RT since version 3.8 has new schema for MySQL versions after 4.1.0\nFollow 
instructions in the UPGRADING.mysql file. at /opt/rt3/bin/webmux.pl line 
146.\nCompilation failed in require at (eval 2) line 1.\n
[Sun Oct 31 12:57:39 2010] [error] Can't load Perl file: 
/opt/rt3/bin/webmux.pl for server 192.168.0.7:80, exiting...

Then I tried:-
etc/upgrade/upgrade-mysql-schema.pl rt3 root PASSWORD > 3.8queries.sql
and:
mysql -u root -p rt3 < ./3.8queries.sql

still fails to start apache
With slightly different errors:
[error] Require of RT::Action:: failed.\nCan't locate RT/Action/.pm in 
@INC (@INC contains: /opt/rt3/bin/../local/lib /opt/rt3/bin/../lib 
/etc/perl /usr/local/lib/perl/5.10.1 /usr/local/share/perl/5.10.1 
/usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 
/usr/local/lib/site_perl . /usr/local/apache2) at (eval 1318) line 
3.\n\nCompilation failed in require at (eval 2) line 1.\n
[Sun Oct 31 13:44:09 2010] [error] Can't load Perl file: 
/opt/rt3/bin/webmux.pl for server 192.168.0.7:80, exiting...

Perhaps I should have dropped the rt-3.8.8 database and created a new 
blank one befor the import?

Any advice much appreciated.

--
Oliver Nash