[rt-users] InnoDB and RT

[steve]

on the old system you do a mysqldump, (if you are running innodb) then 
on the new rt you create the schema and import the sql file that was 
created via the mysql dump.


otherwise you will have to convert from isam to inno, not for the faint 
hearted








Todd Chapman wrote:
> Find and read the documentation at mysql.com.
> 
> On Tue, Feb 01, 2005 at 08:08:57PM +0100, Hilde T Lauvset Rafaelsen wrote:
> 
>>Hi,
>>
>>We have run RT 3.0.10 for a long time. After I start to run mysqldump for backup, we have noticed a problem with duplicate tickets. I found out it is because we not use InnoDB tables in mysql, and I now want to reconfigure mysql and RT to use InnoDB. Can I do this without a new reinstall?
>>
>>I hope someone can give me a hint of what to do here.
>>
>>
>>-------------------------------------
>>Hilde Therese Lauvset Rafaelsen
>>IT-avdelingen, Universitetet i Tromsø
>>Tlf: +47 77 64 58 01 
>>
>>
>>_______________________________________________
>>http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>>RT Administrator and Developer training is coming to your town soon! (Boston, San Francisco, Austin, Sydney) Contact training at bestpractical.com for details.
>>
>>Be sure to check out the RT Wiki at http://wiki.bestpractical.com
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> RT Administrator and Developer training is coming to your town soon! (Boston, San Francisco, Austin, Sydney) Contact training at bestpractical.com for details.
> 
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
> 
>