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 634BE30E60A; Tue, 24 Jun 2003 01:19:26 +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 94951-03; Mon, 23 Jun 2003 22:19:16 -0300 (ADT)
Received: from mobile.hub.org (u153n214.eastlink.ca [24.224.153.214])
	by svr1.postgresql.org (Postfix) with ESMTP
	id 4E03B30DD20; Mon, 23 Jun 2003 22:19:15 -0300 (ADT)
Received: by mobile.hub.org (Postfix, from userid 1001)
	id 989054E8; Mon, 23 Jun 2003 22:19:15 -0300 (ADT)
Received: from localhost (localhost [127.0.0.1])
	by mobile.hub.org (Postfix) with ESMTP
	id 81DEC393; Mon, 23 Jun 2003 22:19:15 -0300 (ADT)
Date: Mon, 23 Jun 2003 22:19:15 -0300 (ADT)
From: The Hermit Hacker <scrappy@postgresql.org>
X-X-Sender: scrappy@hub.org
To: "scott.marlowe" <scott.marlowe@ihs.com>
Cc: Dan Langille <dan@langille.org>, Justin Clift <justin@postgresql.org>,
	"Advocacy (PostgreSQL)" <pgsql-advocacy@postgresql.org>,
	pgsql-general@postgresql.org
Subject: Re: [GENERAL] interesting PHP/MySQL thread
In-Reply-To: <Pine.LNX.4.33.0306231138520.24244-100000@css120.ihs.com>
Message-ID: <20030623221849.S5387@hub.org>
References: <Pine.LNX.4.33.0306231138520.24244-100000@css120.ihs.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Archive-Number: 200306/214
X-Sequence-Number: 1426

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 ... :)