On Tue, Nov 18, 2008 at 6:33 AM, Tim Cutts <t...@sanger.ac.uk> wrote:
> > 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 > Ok now that upgrade completed on the test system, I now see 5000 more tickets already created on the production systems. Do I have to redo this whole thing? I have binlog enabled since the beginning of the original instance. How do I append those new 500 tickets? I guess I am now on a catchup game :-) > > After that, it all seemed to work pretty well. > > Tim > > > -- > The Wellcome Trust Sanger Institute is operated by Genome ResearchLimited, > a charity registered in England with number 1021457 and acompany registered > in England with number 2742969, whose registeredoffice is 215 Euston Road, > London, NW1 2BE. > -- Asif Iqbal PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing?
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com