[rt-users] Postgres to MySQL

[Salensky, Don]

So does anyone know how to do this or where I could start? I have a SQL dump of the Postgres database, but I'm fairly database-retarded and I don't know where to being. Is there any documentation anywhere that would help me? 

Danke schön,
Don
dsalensky at servervault.com


-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Salensky, Don
Sent: Friday, May 27, 2005 12:30 PM
To: rt-users at lists.bestpractical.com
Subject: RE: [rt-users] Postgres to MySQL

No problem. One of the reasons is because RT seems "designed" for MySQL.
Also, MySQL seems a little easier to use and we don't really need the additional functionality of Postgres for RT. And, thinking to future releases of RT, we want the upgrades to go as smoothly as possible.

Thanks,
Don Salensky
dsalensky at servervault.com


-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Jay R.
Ashworth
Sent: Thursday, May 26, 2005 23:18 PM
To: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Postgres to MySQL

On Thu, May 26, 2005 at 02:27:23PM -0400, Salensky, Don wrote:
> We currently have RT running on a Postgres database but we're 
> upgrading to the latest version of RT and we want to switch to MySQL 
> for various reasons. Does anyone know how to convert the data from a 
> Postgres database to MySQL database? Google hath given me nothing.

Not to start an r-war, but I'm curious why?  Do you mind expanding?

Cheers,
-- jra
--
Jay R. Ashworth
jra at baylink.com
Designer                          Baylink
RFC 2100
Ashworth & Associates        The Things I Think
'87 e24
St Petersburg FL USA      http://baylink.pitas.com             +1 727
647 1274

      If you can read this... thank a system administrator.  Or two.
--me _______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com _______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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