[rt-users] migrating from RT 2.0.11/PostgreSQL to RT 2.0.11/MySQL?

[Rehan van der Merwe]

Hi Seth,

Have you been able to resolve this?  I have the same intention now, but
am unsure if it will work OK.  

Else, how did you migrate your Pg db to MySQL?

Rehan van der Merwe
NHA

-----Original Message-----
From: Seth Gordon [mailto:seth at genome.wi.mit.edu] 
Sent: 13 March 2002 07:26
To: rt-users at lists.fsck.com
Subject: [rt-users] migrating from RT 2.0.11/PostgreSQL to RT
2.0.11/MySQL?

I have been running an RT server on a machine with PostgreSQL for a few
months, and now I want to migrate all the ticket information to another
installation, which runs MySQL.  In PostgreSQL, the output of "pg_dump
<database>" appears to be the sequence of SQL commands that would be
necessary to reconstruct the database.  If I just dump the PostgreSQL RT
database, and then use whatever MySQL's "execute all the SQL in this
file" is to rebuild the database on the new server, will I have a
problem?  Do I have to massage the dump file in some way to make it
conform to MySQL syntax or to match some configuration detail in the
other system?

The new installation has no tickets, queues, or users on it that I care
about preserving.  Both are running RT 2.0.11.