On Sun, Oct 03, 2010 at 12:28:41PM +0100, Dominic Hargreaves wrote: > On Fri, Oct 01, 2010 at 04:06:52PM -0400, Josh Narins wrote: > > I'm converting a 2.0.15 RT system with mysql to 3.8.8 using Kai's > > scripts.[1] > > > > For performance reasons, he drops the indices before the insert, then > > recreates them after. All perfectly logical, but his scripts were based on > > 3.8.4 > > > > I wanted to make sure that no indices had changed between 3.8.4 and 3.8.8 > > so that the index recreation works as expected. > > No index changes have taken place since 3.8.4. > See etc/upgrade/3.8.* for confirmation.
Actually, UPGRADING has something to say about index upgrades on MySQL and Oracle, you might like to check that out. Dominic. -- Dominic Hargreaves, Systems Development and Support Team Computing Services, University of Oxford
signature.asc
Description: Digital signature
RT Training in Washington DC, USA on Oct 25 & 26 2010 Last one this year -- Learn how to get the most out of RT!
