public inbox for [email protected]  

help / color / mirror / Atom feed

From: Jose Apablaza <[email protected]>
To: Jeff MacDonald <[email protected]>
Cc: [email protected]
Cc: [email protected]
Subject: Re: MySQL DB to PostgresSQL DB
Date: Tue, 16 May 2006 10:45:05 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>

Hello,

On 5/16/06, Jeff MacDonald <[email protected]> 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=en&q=mysql+to+postgresql&btnG=Google
> +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/
>
>


-- 
José Apablaza
Telecommunications Engineer
Skype: pruebagp

view thread (4+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: MySQL DB to PostgresSQL DB
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox