Re: Mysql to Postgresql

From: Jaime Crespo Rincón <jcrespo(at)warp(dot)es>
To: Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, mysql(at)lists(dot)mysql(dot)com
Subject: Re: Mysql to Postgresql
Date: 2011-02-22 09:25:12
Message-ID: AANLkTi=vtfn+C16YHErcOV9yR_BCaoC1TdM9666TTsPZ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2011/2/22 Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com>:
> Dear all,
>
> Today I need to back up a mysql database and restore in Postgresql database
> but I don't know how to achieve this accurately.

Have a look at: "mysqldump --compatible=postgresql" command:
<http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_compatible>

Anyway, most of the times you will need a more manual migration, with
human intervention (custom scripts) and migrating the data through
something like CSV (SELECT... INTO OUTFILE).

--
Jaime Crespo
MySQL & Java Instructor
Software Developer
Warp Networks
<http://warp.es>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message rsmogura 2011-02-22 09:59:03 System trigger
Previous Message Adarsh Sharma 2011-02-22 09:21:01 Mysql to Postgresql