pg.ddx.io pgsql-php@postgresql.org mailing list archive
help / color / mirror / Atom feedmysql to pgsql
3+ messages / 3 participants
[nested] [flat]
* mysql to pgsql
@ 2003-08-28 04:41 K. Suresh <suresh@ooty.tenet.res.in>
2003-08-28 09:56 ` Re: mysql to pgsql CoL <col@mportal.hu>
2003-08-28 10:02 ` Re: mysql to pgsql Gerd Terlutter <gerd@MplusB.de>
0 siblings, 2 replies; 3+ messages in thread
From: K. Suresh @ 2003-08-28 04:41 UTC (permalink / raw)
To: pgsql-php
Hello,
I have a database application with Java and PHP clients. I used mysql
with 64 tables. Now, we have decided to use pgsql. Please suggest the
migration procedure.
Thanks.
Suresh
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: mysql to pgsql
2003-08-28 04:41 mysql to pgsql K. Suresh <suresh@ooty.tenet.res.in>
@ 2003-08-28 09:56 ` CoL <col@mportal.hu>
1 sibling, 0 replies; 3+ messages in thread
From: CoL @ 2003-08-28 09:56 UTC (permalink / raw)
To: pgsql-php
http://www.google.com/search?q=mysql2psql&sourceid=mozilla-search&start=0&start=0&ie...
->
http://gborg.postgresql.org/project/mysql2psql/projdisplay.php
C.
K. Suresh wrote, On 8/28/2003 6:41 AM:
> Hello,
>
> I have a database application with Java and PHP clients. I used mysql
> with 64 tables. Now, we have decided to use pgsql. Please suggest the
> migration procedure.
>
> Thanks.
>
> Suresh
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: mysql to pgsql
2003-08-28 04:41 mysql to pgsql K. Suresh <suresh@ooty.tenet.res.in>
@ 2003-08-28 10:02 ` Gerd Terlutter <gerd@MplusB.de>
1 sibling, 0 replies; 3+ messages in thread
From: Gerd Terlutter @ 2003-08-28 10:02 UTC (permalink / raw)
To: K. Suresh <suresh@ooty.tenet.res.in>; +Cc: pgsql-php
K. Suresh wrote:
> Hello,
>
> I have a database application with Java and PHP clients. I used mysql
> with 64 tables. Now, we have decided to use pgsql. Please suggest the
> migration procedure.
>
> Thanks.
>
> Suresh
>
Hi all,
for a few weeks i had the same problem. I found the attached script, doc
is online :
http://ns2.ziet.zhitomir.ua/~fonin/projects/my2pg/my2pg_man.html
shortcut :
mysqldump -u username --password=mypasswd databasetodump [tables]
|(pipe) my2pg.pl>dumpfile
dumpfile the script that you can use to create tables in an already
existing PG-dbase. If you need functions in PG (e.g. you need enum in
mysql) you have to read the file as PG-superuser and not as owner of the
db. The my2pg.pl script creates Makefile and three libtypes.*. You need
a specific pg-libary on your system, but i've forgotten the name. If you
convert as superuser, don't forget to give the privs to the user (grant
all on 'tablename' to 'user). do the same for *_seq-tables.
hope it helps
Gerd
--
--------------------------------------------------------
# Gerd Terlutter | Mueller+Blanck Software GmbH #
# gerd@MplusB.de | Gutenbergring 38 #
# gerd.terlutter@web.de | D-22848 Noderstedt #
# tel:0171/6992579 | tel:+49 40 500 171-1 #
# Buero:040/500171-17 | fax:+49 40 500 171-71 #
--------------------------------------------------------
Attachments:
my2pg.pl (application/x-perl, 25.1K) download
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-08-28 10:02 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-08-28 04:41 mysql to pgsql K. Suresh <suresh@ooty.tenet.res.in>
2003-08-28 09:56 ` CoL <col@mportal.hu>
2003-08-28 10:02 ` Gerd Terlutter <gerd@MplusB.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox