[rt-users] Rt at Glance and upgrade from 3.2.1 to 3.8.0

[Jean-Michel Barbet]

Ruslan Zakirov wrote:
> 1) try 3.8.1rc5
> 2) do you upgrade mysql as well?

Hi Ruslan,

No, I did not try 3.8.1rc5, I am still with 3.8.0.
What I am doing is transfering the RT databse from a server under
Fedora Core release 2 (Tettnang), MySQL-server-4.0.20-0, RT 3.2.1
to a distinct newly installed server  under Scientific Linux SL release
5.2 (Boron) (equivalent to a RHEL 5.2) with mysql-server-5.0.45-7.el5
and RT 3.8.0.

Finally I made a satisfying migration by doing the following :

1) dump separately the data and the structure of existing RT3.2.1
    database
2) load the structure only on the new RT (not the data)

3) run a scrip that declares the column type to UTF8 for each field
    that I want to be preserved because it is already in UTF8;
    do not modify the table default character yet (example for the
    column "Subject" of table "Attachments" :
USE rt3;
ALTER TABLE Attachments MODIFY Subject VARBINARY(255) NULL DEFAULT NULL;
ALTER TABLE Attachments MODIFY Subject VARCHAR(255) CHARACTER SET utf8
NULL DEFAULT NULL;

4) load the data on the new RT

5) create and run the mySQL upgrade script :

perl etc/upgrade/schema.mysql-4.0-4.1-new.pl rt3 rt_user xxxxx > \
mysqlupgrade.sql
mysql -u root -p rt3 < mysqlupgrade.sql

6) upgrade the schema :

/opt/rt3/sbin/rt-setup-database --dba root \
--prompt-for-dba-password --action upgrade
[...]
Enter RT version you're upgrading from: 3.2.1
[...]

7) restart server

rm -fr /opt/rt3/var/mason_data/obj
service httpd restart

With this procedure, I am happy :-)

Your comments are welcome.

Especially, should I use 3.8.1rc5 for production rather than 3.8.0 ?
and why ...

Thank you very much.

JM

-- 
------------------------------------------------------------------------
Jean-michel BARBET                    | Tel: +33 (0)2 51 85 84 86
Laboratoire SUBATECH Nantes France    | Fax: +33 (0)2 51 85 84 79
CNRS-IN2P3/Ecole des Mines/Universite | E-Mail: barbet at subatech.in2p3.fr
------------------------------------------------------------------------