[rt-users] converting MyISAM to InnoDB tables for upgrades

[Schultz, Eric]

> So, after a reading some posts to this list recommending it,  
> I converted
> RT's tables from  InnoDB  to MyISAM. The table type for our 
> RT install has
> remained MyISAM ever since.
> -- 
> Mike Kukla
> Web Programmer/Assistant Unix Administrator
> College of Art and Sciences, Educational Technology
> 414 Clemens Hall
> 645-6000 x1156
> kukla at caset.buffalo.edu

The conversion from MyISAM back to InnoDB should be just as easy as the
original conversion from InnoDB to MyISAM - just a matter of a simple
"alter table" statement for each table (can be a perl one-liner on the
unix CL).

Eric Schultz
United Online