possibly updating techdocs; mysql2pgsql on gborg

I don't see the old link you are referring to (and neither did grep); is
this on the main page of techdocs or someplace else?

Robert Treat

On Thu, 2004-07-01 at 01:02, joseph speigle wrote:

hi
,
I am on a mission to simply keep a starving project off the ground by updating an old mysql->pgsql perl conversion script which does its conversion very differently from the one under contrib/. There is an old link to
http://www.rot13.org/~dpavlin/sql.html
on techdocs under the section

Converting from other Databases to PostgreSQL

in a section which was apparently "Last updated 7th September 2002"

If anybody still has access to that page, the project has moved to gborg specifically
over to

http://gborg.postgresql.org/project/mysql2psql/projdisplay.php

where a new version of the perl conversion script is located.

"Can the link be updated?"

The version on gborg has cvs access and multiple developers, and is being maintained bymyself. I would be amazed if nobody else tweaked it in its weak spots.

thanks,

joe speigle

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

I have updated the /contrib/mysql/README file to point to the new URL's.
Thanks.

---------------------------------------------------------------------------

Robert Treat wrote:

I don't see the old link you are referring to (and neither did grep); is
this on the main page of techdocs or someplace else?

Robert Treat

On Thu, 2004-07-01 at 01:02, joseph speigle wrote:

hi
,
I am on a mission to simply keep a starving project off the ground by updating an old mysql->pgsql perl conversion script which does its conversion very differently from the one under contrib/. There is an old link to
http://www.rot13.org/~dpavlin/sql.html
on techdocs under the section

Converting from other Databases to PostgreSQL

in a section which was apparently "Last updated 7th September 2002"

If anybody still has access to that page, the project has moved to gborg specifically
over to

http://gborg.postgresql.org/project/mysql2psql/projdisplay.php

where a new version of the perl conversion script is located.

"Can the link be updated?"

The version on gborg has cvs access and multiple developers, and is being maintained bymyself. I would be amazed if nobody else tweaked it in its weak spots.

thanks,

joe speigle

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

!DSPAM:40e46b7246695510113564!

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Robert, Bruce,

If anybody still has access to that page, the project has moved to
gborg specifically over to

http://gborg.postgresql.org/project/mysql2psql/projdisplay.php

where a new version of the perl conversion script is located.

There's one of these on GBorg too? I started on on pgFoundry because I made a
bunch of changes to the script (which now need debugging). Since this one
needs nothing but CVS, any objections to just migrating it?

--
Josh Berkus
Aglio Database Solutions
San Francisco

Josh Berkus wrote:

Robert, Bruce,

If anybody still has access to that page, the project has moved to
gborg specifically over to

http://gborg.postgresql.org/project/mysql2psql/projdisplay.php

where a new version of the perl conversion script is located.

There's one of these on GBorg too? I started on on pgFoundry because I made a
bunch of changes to the script (which now need debugging). Since this one
needs nothing but CVS, any objections to just migrating it?

Makes sense. Please be sure they haven't made additions themselves.
Also send me the new URL so I can update contrib.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

hi,
just a contrib/mysql/README patch. Somehow the links got reversed.

5c5
< http://gborg.postgresql.org/project/mysql2psql/projdisplay.php
---

http://www.omnistarinc.com/~fonin/downloads.php#my2pg

9c9
< Another tool, mysql2pgsql, can be found at:
---

A third tool, mysql2pgsql.perl, can be found at:

11c11
< http://www.omnistarinc.com/~fonin/downloads.php#my2pg
---

http://gborg.postgresql.org/project/mysql2psql/projdisplay.php

On Thu, Jul 15, 2004 at 12:45:51AM -0400, Robert Treat wrote:

Hey Joseph, just noticed this in my drafts folder... not sure why it was
there, hope it makes sense to you :-)

----
OK, I have updated the link on the techdocs site, and after looking at your
project statement have a few recommendations for you. The first is that you
need to put some mention that your script is a descendant of Dobrica's script
just to give props to those who came before but also so people know to use
your script over the old one. Second, you need to send a patch to
pgsql-patches for the postgresql core server that updates
contrib/mysql/README and contrib/mysql/mysql2pgsql.pl to reference your newer
script. Since we are technically past feature freeze, you need to include a
list of any bugs that were fixed in the old script by the new script.

Hope this helps.

Robert Treat

On Thursday 01 July 2004 17:22, you wrote:

I don't see the old link you are referring to (and neither did grep); is
this on the main page of techdocs or someplace else?

Robert Treat

If the main page is http://techdocs.postgresql.org/
(which may be index.htm or index.php but my browser doesn't show) that is
where the outdated link is.

This is what I see when I do "view source" on that page:

<li><a
href="/redir.php?link=http://docman.sourceforge.net/home_html/projects/sql/
mysql2pgsql" target="_blank">mysql2pgsql</a> - A Perl script used to convert
MySQL databases dump to a PostgreSQL-compatible format, by <a
href="/redir.php?link=mailto:dpavlin@rot13.org" target="_blank">Dobrica
Pavlinusic</a></li>

HISTORY
=======
Dobrica Pavlinusic has a project called docman at sourceforge
In a subdirectory of the project there he put the file mysql2pgsql
That file on sourceforge hasn't been edited since 19-Apr-2001 (dir listing)
The most recent version of the mysql2pgsql script is at
http://gborg.postgresql.org/project/mysql2psql/projdisplay.php

thanks for your reply.

joesp

--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

Thanks, fixed.

---------------------------------------------------------------------------

joe speigle wrote:

hi,
just a contrib/mysql/README patch. Somehow the links got reversed.

5c5
< http://gborg.postgresql.org/project/mysql2psql/projdisplay.php
---

http://www.omnistarinc.com/~fonin/downloads.php#my2pg

9c9
< Another tool, mysql2pgsql, can be found at:
---

A third tool, mysql2pgsql.perl, can be found at:

11c11
< http://www.omnistarinc.com/~fonin/downloads.php#my2pg
---

http://gborg.postgresql.org/project/mysql2psql/projdisplay.php

On Thu, Jul 15, 2004 at 12:45:51AM -0400, Robert Treat wrote:

Hey Joseph, just noticed this in my drafts folder... not sure why it was
there, hope it makes sense to you :-)

----
OK, I have updated the link on the techdocs site, and after looking at your
project statement have a few recommendations for you. The first is that you
need to put some mention that your script is a descendant of Dobrica's script
just to give props to those who came before but also so people know to use
your script over the old one. Second, you need to send a patch to
pgsql-patches for the postgresql core server that updates
contrib/mysql/README and contrib/mysql/mysql2pgsql.pl to reference your newer
script. Since we are technically past feature freeze, you need to include a
list of any bugs that were fixed in the old script by the new script.

Hope this helps.

Robert Treat

On Thursday 01 July 2004 17:22, you wrote:

I don't see the old link you are referring to (and neither did grep); is
this on the main page of techdocs or someplace else?

Robert Treat

If the main page is http://techdocs.postgresql.org/
(which may be index.htm or index.php but my browser doesn't show) that is
where the outdated link is.

This is what I see when I do "view source" on that page:

<li><a
href="/redir.php?link=http://docman.sourceforge.net/home_html/projects/sql/
mysql2pgsql" target="_blank">mysql2pgsql</a> - A Perl script used to convert
MySQL databases dump to a PostgreSQL-compatible format, by <a
href="/redir.php?link=mailto:dpavlin@rot13.org" target="_blank">Dobrica
Pavlinusic</a></li>

HISTORY
=======
Dobrica Pavlinusic has a project called docman at sourceforge
In a subdirectory of the project there he put the file mysql2pgsql
That file on sourceforge hasn't been edited since 19-Apr-2001 (dir listing)
The most recent version of the mysql2pgsql script is at
http://gborg.postgresql.org/project/mysql2psql/projdisplay.php

thanks for your reply.

joesp

--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

On Tuesday 13 July 2004 09:06, Bruce Momjian wrote:

Josh Berkus wrote:

Robert, Bruce,

If anybody still has access to that page, the project has moved to
gborg specifically over to

http://gborg.postgresql.org/project/mysql2psql/projdisplay.php

where a new version of the perl conversion script is located.

There's one of these on GBorg too? I started on on pgFoundry because I
made a bunch of changes to the script (which now need debugging). Since
this one needs nothing but CVS, any objections to just migrating it?

You need to contact the guy who contacted me... when the two of you hash it
out send me an email and I'll update techdocs with the proper link (or both
if thats how its resolved)

Makes sense. Please be sure they haven't made additions themselves.
Also send me the new URL so I can update contrib.

Maybe this should be removed from contrib?

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

Robert,

Maybe this should be removed from contrib?

We agreed to remove the "mysql" folder from contrib about 6 months ago, on
Hackers.

--
-Josh Berkus
Aglio Database Solutions
San Francisco