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

[Seth Gordon]

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.

-- 
"Any fool can write code that a computer can understand.
 Good programmers write code that humans can understand."
 --Martin Fowler
// seth gordon // wi/mit ctr for genome research //
// seth at genome.wi.mit.edu // standard disclaimer //