X-Original-To: pgsql-advocacy-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.193])
	by svr1.postgresql.org (Postfix) with ESMTP
	id 4B92930EB5B; Tue, 24 Jun 2003 01:46:59 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new,
	port 10024)
	with ESMTP id 92586-06; Mon, 23 Jun 2003 22:46:49 -0300 (ADT)
Received: from bast.unixathome.org (bast.unixathome.org [66.11.174.150])
	by svr1.postgresql.org (Postfix) with ESMTP
	id 8F39330DD20; Mon, 23 Jun 2003 22:46:48 -0300 (ADT)
Received: from wocker (wocker.unixathome.org [192.168.0.99])
	by bast.unixathome.org (Postfix) with ESMTP
	id 9EAF93D28; Mon, 23 Jun 2003 21:46:49 -0400 (EDT)
From: "Dan Langille" <dan@langille.org>
To: The Hermit Hacker <scrappy@postgresql.org>,
	Dan Langille <dan@langille.org>, Justin Clift <justin@postgresql.org>,
	"Advocacy (PostgreSQL)" <pgsql-advocacy@postgresql.org>,
	pgsql-general@postgresql.org
Date: Mon, 23 Jun 2003 21:46:49 -0400
MIME-Version: 1.0
Subject: Re: [GENERAL] interesting PHP/MySQL thread
Cc: Dan Langille <dan@langille.org>, Justin Clift <justin@postgresql.org>,
	"Advocacy (PostgreSQL)" <pgsql-advocacy@postgresql.org>,
	pgsql-general@postgresql.org
Message-ID: <3EF77549.27956.37006501@localhost>
References: <Pine.LNX.4.33.0306231138520.24244-100000@css120.ihs.com>
In-reply-to: <20030623221849.S5387@hub.org>
X-mailer: Pegasus Mail for Windows (v4.02a)
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
Content-description: Mail message body
X-Archive-Number: 200306/215
X-Sequence-Number: 1427

On 23 Jun 2003 at 22:19, The Hermit Hacker wrote:

> On Mon, 23 Jun 2003, scott.marlowe wrote:
> 
> > On Mon, 23 Jun 2003, Dan Langille wrote:
> >
> > > On 24 Jun 2003 at 1:02, Justin Clift wrote:
> > >
> > > > "PostgreSQL v7.4 released, including enhanced MySQL->PostgreSQL
> > > > migration tools".
> > >
> > > On this very note, I'm attempting to migrate MySQL database to
> > > PostgreSQL right now.  I'm getting stuck on data such as this:
> > >
> > > (155,'<HTML>tr -d \"\015\" < dosfile.txt\r\n</HTML>',155)
> > >
> > > Where can I find this migration tool? The one I was using was pgAdmin
> > > II via ODBC.
> >
> > It's in the contrib/mysql directory in the source file.  the name of the
> > script is mysql2pgsql.  Don't kow how well it will work, as I've never
> > migrated from MySQL to Postgresql myself.
> 
> But, if you happen to find problems, let us know so that we can strengthen
> it before v7.4 goes out ... :)

Well, for what it's worth, I only need to convert the data, the 
tables will be created by the application.

background: I'm converted an installation of http://www.phorum.org/ 
from mysql to pg.  I'd rather Phorum create the PG tables, and just 
copy the data over.  So far, the proof-of-concept has gone well.
-- 
Dan Langille : http://www.langille.org/