public inbox for [email protected]  

help / color / mirror / Atom feed

From: Robert Treat <[email protected]>
To: [email protected]
Cc: Jason McManus <[email protected]>
Subject: Re: Notes on converting from MySQL 5.0.x to PostgreSQL 8.1.4
Date: Mon, 3 Jul 2006 11:33:00 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

On Friday 30 June 2006 09:17, Jason McManus wrote:
> On Converting from MySQL 5.0.x to PostgreSQL 8.1.x
> * There is a conversion utility called 'mysql2pgsql' that will convert
>   dump files from the mysqldump format, to a format that psql can
>   understand.  It is available at:
>   - http://gborg.postgresql.org/project/mysql2psql/projdisplay.php

FWIW, I have some decent success using mysqls mysqldump programm with various 
--postgresql-compataible flags to get postgresql workable dumps.  The flag 
tree of that program is a killer, but if you can figure out the right flags, 
the output is pretty good. 

-- 
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

view thread (38+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Notes on converting from MySQL 5.0.x to PostgreSQL 8.1.4
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox