From: | "Dan Langille" <dan(at)langille(dot)org> |
---|---|
To: | The Hermit Hacker <scrappy(at)postgresql(dot)org>, Dan Langille <dan(at)langille(dot)org>, Justin Clift <justin(at)postgresql(dot)org>, "Advocacy (PostgreSQL)" <pgsql-advocacy(at)postgresql(dot)org>, pgsql-general(at)postgresql(dot)org |
Cc: | Dan Langille <dan(at)langille(dot)org>, Justin Clift <justin(at)postgresql(dot)org>, "Advocacy (PostgreSQL)" <pgsql-advocacy(at)postgresql(dot)org>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: [GENERAL] interesting PHP/MySQL thread |
Date: | 2003-06-24 01:46:49 |
Message-ID: | 3EF77549.27956.37006501@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-docs pgsql-general |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Dan Langille | 2003-06-24 01:55:25 | good candidate for Win32 testing |
Previous Message | The Hermit Hacker | 2003-06-24 01:19:15 | Re: [GENERAL] interesting PHP/MySQL thread |
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew Nuzum | 2003-06-24 02:58:07 | Re: interesting PHP/MySQL thread |
Previous Message | The Hermit Hacker | 2003-06-24 01:19:15 | Re: [GENERAL] interesting PHP/MySQL thread |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-06-24 01:54:41 | Re: Why can't you define a table alias on an update? |
Previous Message | The Hermit Hacker | 2003-06-24 01:19:15 | Re: [GENERAL] interesting PHP/MySQL thread |