Upgrading from Win32 Version 3.0.12 to RHEL4 3.4.2

I am attempting to migrate our rt3 database from our Win32 3.0.12
version of RT to a RHEL4 box with RT 3.4.2. I will be doing a mysqldump
in the morning from the Windows machine but, to be honest, I’m lost from
there. Has anyone done this or can anyone give me some general
directions on how to move the database from one machine to the other and
ensure that the schema is correct?
Here is what I have right now:
RT 3.0.12 for Windows installed on a 2000 Server box with about 200
tickets.

RT 3.4.2 installed on RHEL4.

I’ve tested the instance on the redhat box and it’s working properly so
I just need to move my database over.

Thanks,
mhb

Michael H. Brown
Network Administrator
Senex Services Corp.
317.613.3000 ext. 217
http://www.senexservicescorp.com

Michael H. Brown wrote:

I am attempting to migrate our rt3 database from our Win32 3.0.12
version of RT to a RHEL4 box with RT 3.4.2. I will be doing a mysqldump
in the morning from the Windows machine but, to be honest, I’m lost from
there. Has anyone done this or can anyone give me some general
directions on how to move the database from one machine to the other and
ensure that the schema is correct?

Here is what I have right now:

RT 3.0.12 for Windows installed on a 2000 Server box with about 200 tickets.

  1. Move your data with mysqldump to RHEL
  2. unpack RT tarball
  3. read README and other text files for UPGRADE instructions, you must
    run scripts that will upgrade your DB schema from 3.0.x to 3.4.x.
  4. You can skip source code installation because you allready have
    installed 3.4.2 on RHEL, configure it to use new DB.