[Rt-devel] Migrating RT DB from mysql 4.1.11 to 5.0.51

[Vick Khera]

> On Tue, May 19, 2009 at 5:40 PM,  <Arnas.Kupsys at swisscom.com> wrote:
>> Hello we are running RT for our company's day to day request handling, and customer center issue logging.
>> We want to migrate RT DB to a new machine (newer OS and new mysql version).
>> But facing the problems due to the big DB size and table encodings.

We recently upgraded from Postgres 8.0 (or 8.1 I don't recall which)
to 8.3, which had stricted UTF-8 checking, and we had to manually go
in and fix up all the UTF-8 errors that were allowed to creep in.  It
was painful, but scripting it helped a lot... :-)

It sounds really like you have a mysql bug.  It seems the correct
forum for you is where you filed your bug report.