On 17 Nov 2008, at 10:34 pm, Asif Iqbal wrote: > Do I upgrade from RT 3.4.5 to RT 3.8.1 directly? Or there is a roadmap > somewhere?
You can do this in almost one go, yes. It's almost exactly what I'm doing with my production RT, where I'm going from 3.4.2 to 3.8.1 > > Do I upgrade the mysql 4.0.24 to 4.1 first before upgrading the RT? Yes. Or at least, here's what I've tested, and seems to work quite well: 1) Set up a new RT box for your new server, so that you can always back out if this goes wrong. On this server, install the new version of MySQL you want to use, and install RT 3.8.1 2) Make a dump of your production MySQL instance, and load it into the new MySQL database. 3) Run the /opt/rt3/sbin/rt-setup-database --action upgrade command as detailed in the RT 3.8.1 README file, but only as far as version 3.8.0 4) Run the MySQL upgrade script, as detailed in UPGRADING.mysql, and apply the SQL statements it wants you to make. This can take a long time; the alter table statements are pretty slow-running. 5) Run the /opt/rt3/sbin/rt-setup-database --action upgrade thing again for the last small changes from 3.8.0 to 3.8.1 After that, it all seemed to work pretty well. Tim -- The Wellcome Trust Sanger Institute is operated by Genome Research Limited, a charity registered in England with number 1021457 and a company registered in England with number 2742969, whose registered office is 215 Euston Road, London, NW1 2BE. _______________________________________________ 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