Date: Fri, 5 Sep 2008 08:03:16 +1200
From: Steve Holdoway <steve.holdoway@firetrust.com>
To: pgsql-admin@postgresql.org
Subject: Re: Database Conversion
Message-Id: <20080905080316.8c88dcd4.steve.holdoway@firetrust.com>
In-Reply-To: <9B852776-95B1-41E2-B6A8-DFA92F7C410F@indiana.edu>
References: <9B852776-95B1-41E2-B6A8-DFA92F7C410F@indiana.edu>
Organization: Firetrust Ltd.
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

On Thu, 4 Sep 2008 09:24:34 -0400
Carol Walter <walterc@indiana.edu> wrote:

> Hello, All,
> 
> I have a new faculty member who has a large database that is in  
> MySQL.  We don't support MySQL so the database needs to be ported to  
> PostgreSQL.  Her GA, who know MySQL, says that he has a query that he  
> will run that will put the data into postgres.  I thought that the  
> data would have to be output to a text file and then copied into  
> postgres.  I don't know MySQL.  I've done a conversion from Oracle  
> and this is how I did it.  Is he correct that he can put the data  
> into a postgres database by running a MySQL query?  It doesn't sound  
> possible to me.
> 
> Carol
> 
> -- 
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
I'd use mysqldump to create 2 files: the first being the schema, which I'd tweak to suit ( implementing tablespaces for example ), and then a second dump, which exports the data in a format that is acceptable to postgres.

That way, you end up with what you want in a simple, repeatable manner.

If it's mysql 5 then the stored procedures may need to be converted - I know there are tools out there, but haven't used them and can't comment.

Steve
-- 
Steve Holdoway <steve.holdoway@firetrust.com>