[rt-users] Moving rt from mysql 3.23 to 4.1?

[Ruslan U. Zakirov]

Howard Jones wrote:
> Hi,
> 
> I'm about to update our RT install from 3.0.10 to 3.4.2, and I noticed 
> that the requirements for RT say mysql 4.1. We've been running it on 
> 3.23 for a couple of years now, and I've just updated mysql to 4.1 on 
> that server, using the existing (MyISAM) tables.
> 
> What I'd like to know is:
> 1) Is it worth moving to InnoDB?
You must use InnoDB engine for RT even 3.0.XX uses transactions, but in 
recent versions there is can be buggy behaviour without transactions 
support.

> 2) My plan for doing that would be to finish the upgrade to RT 3.4.2 
> first, then look at moving the database after by using the conversion 
> scripts for 3.4.2, then dumping the database, replacing all the 'MyISAM' 
> in the dump with 'InnoDB', then reloading that dump. Is that going to work?
yes, but I suggest convert to InnoDB first.

> 
> Thanks in advance for any advice - I'm looking forward to 3.4's new 
> features :-)
> 
> Best Regards,
> 
> Howard
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
>