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: [EMAIL PROTECTED]
------------------------------------------------------------------------
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
