InnoDB and RT

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

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@bestpractical.com for details.

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

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: