X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 824AD9FA4EA for ; Tue, 16 May 2006 05:45:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 97030-04 for ; Tue, 16 May 2006 05:45:09 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.207]) by postgresql.org (Postfix) with ESMTP id 2468C9F944D for ; Tue, 16 May 2006 05:45:08 -0300 (ADT) Received: by nz-out-0102.google.com with SMTP id s18so235486nze for ; Tue, 16 May 2006 01:45:08 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=Xz88Xt36TXG+/hUOdxirOEDu9mHFgNzQNPEV6Q8ilm9b/KI8Iv5nuRfdRTDcY+OMuxkQFpO6/mFPobfmW5jN9ig96qHcC/SIEvTwBMO+2DTZIfiZxJEEDmMnQfXOfjI8h3LFS0kdz00OdfOlWsac9UXdKys1TGRrfDZekgMNGcw= Received: by 10.36.247.45 with SMTP id u45mr4025062nzh; Tue, 16 May 2006 01:45:05 -0700 (PDT) Received: by 10.36.34.2 with HTTP; Tue, 16 May 2006 01:45:05 -0700 (PDT) Message-ID: <4425c4c70605160145p52cc426eoe6d9ab5b7a5401db@mail.gmail.com> Date: Tue, 16 May 2006 10:45:05 +0200 From: "Jose Apablaza" To: "Jeff MacDonald" Subject: Re: MySQL DB to PostgresSQL DB Cc: pgsql-novice@postgresql.org, pgsql-www@postgresql.org In-Reply-To: <1147735575.12905.7.camel@dionysus.zoidtechnologies.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_19494_15353011.1147769105738" References: <4425c4c70605151519l4b698edbs7e11b12a697f495d@mail.gmail.com> <1147735575.12905.7.camel@dionysus.zoidtechnologies.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/73 X-Sequence-Number: 10036 ------=_Part_19494_15353011.1147769105738 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hello, On 5/16/06, Jeff MacDonald wrote: > > greetings, > > I don't know if pgsql-www is the right place for your questions or not, > but I'll be nice and give you a few ideas on how to get your questions > answered.. :) Thank a lot for your answers Jeff, On Tue, 2006-05-16 at 00:19 +0200, Jose Apablaza wrote: > > Dear all, > > > > This is my first post and I will try to be short and clear in my > > questions and I hope you can help me with that. > > > > I have a MySQL DB and I want to export to PostgreSQL DB. > > > > My questions are; > > > > - Is posible to export MySQL DB to PostgreSQL DB? > > directly? without modification? not sure about that. at the very least > many of the field types are different in pg vs. other databases like > mysql. you'll need to run a script or do a search-and-replace to resolve > that. > > > - Does PostgreSQL DB has tools to import MySQL DB? > > - If is posible, How do I need to build the DB in MySQL?, in order to > > have success in the exportation. > > - Do someone did it before?, exporting MySQL DB to PostgreSQL DB? > > many people have converted from mysql to postgresql. > > > - What kind of risk do we can to have in this process? > > depends on what exactly mysql is doing for you now. I have a web page on ActionApps (MySQL) and the idea is move it to OpenACS (PostgreSQL) > - How long can take this process? > > depends on the size of the database and skill at this sort of thing. > also, if you are using mysql_* calls from (for example) php, you will > need to convert that code. personally, I recommend PEAR::DB (assuming > php is being used).. that way once you have the database imported to pg, > you change the connect string and you are done. info about PEAR::DB is > here: http://pear.php.net/DB ... you might also try > http://pear.php.net/MDB2 , but I do not have personal experience with > that module. > > I did a google search: > http://www.google.com/search?hl=3Den&q=3Dmysql+to+postgresql&btnG=3DGoogl= e > +Search > > and found a number of links that might help you in your quest. if none > of those links are helpful, please let me know privately. > > another recommendation I would make after using google and reading up on > a few things is to ask about this process on irc.. #postgresql on > irc.freenode.net is an *excellent* resource. > > > > > Thanks in advance. > > > > Jose > > > > regards, > J > -- > Jeff MacDonald > Zoid Technologies, http://zoidtechnologies.com/ > > --=20 Jos=E9 Apablaza Telecommunications Engineer Skype: pruebagp ------=_Part_19494_15353011.1147769105738 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hello,

On 5/16/06, Jeff MacDonald <jam@zoidtechnologies.com> wrote:
greetings,

I don't know if pgsql-www is the right place for your que= stions or not,
but I'll be nice and give you a few ideas on how to get y= our questions
answered.. :)

Thank a lot for your answers Jeff,

On Tue,= 2006-05-16 at 00:19 +0200, Jose Apablaza wrote:
> Dear all,
>
> This is my first post and I will try to be short and clear in my> questions and I hope you can help me with that.
>
> I ha= ve a MySQL DB and I want to export to PostgreSQL DB.
>
> My que= stions are;
>
> - Is posible to export MySQL DB to PostgreSQL DB?

d= irectly? without modification? not sure about that. at the very least
ma= ny of the field types are different in pg vs. other databases like
mysql= . you'll need to run a script or do a search-and-replace to resolve
that.

> - Does PostgreSQL DB has tools to import MySQL DB?> - If is posible, How do I need to build the DB in MySQL?, in order to=
> have success in the exportation.
> - Do someone did it befor= e?, exporting MySQL DB to PostgreSQL DB?

many people have converted from mysql to postgresql.

> - = What kind of risk do we can to have in this process?

depends on what= exactly mysql is doing for you now.

I have a web page on ActionApps (MySQL) and the idea is move it to OpenACS = (PostgreSQL)
 

&= gt; - How long can take this process?

depends on the size of the dat= abase and skill at this sort of thing.
also, if you are using mysql_* calls from (for example) php, you willneed to convert that code. personally, I recommend PEAR::DB (assuming
= php is being used).. that way once you have the database imported to pg,
you change the connect string and you are done. info about PEAR::DB is<= br>here: http://pear.php.net/DB ... = you might also try
http://pear.php.= net/MDB2 , but I do not have personal experience with
that module.

I = did a google search:
http://www.google.com/search?hl= =3Den&q=3Dmysql+to+postgresql&btnG=3DGoogle
+Search

and found a number of links that might help you in y= our quest. if none
of those links are helpful, please let me know privat= ely.

another recommendation I would make after using google and read= ing up on
a few things is to ask about this process on irc.. #postgresql on
irc.freenode.net is an *excellent* re= source.

>
> Thanks in advance.
>
> Jose
>

regards,
J
--
Jeff MacDonald
Zoid Technologies, http://zoidtechnologies.com/

<= /blockquote>



--
Jos=E9 Apablaza
Telec= ommunications Engineer
Skype: pruebagp ------=_Part_19494_15353011.1147769105738--