Re: Mysql to Postgresql

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.

In addition to other suggestions, you could also use open source Tungsten
Replicator which has real-time MySQL to PostgreSQL replication capabilities.
Though, if you only need to do it once, this might be overwhelming in your
case. On the other hand, if you need to migrate out with minimum downtime
and Q&A you might want to check it out.

We've done a webinar a week back which recording you can watch from
http://www.continuent.com/news/webinars - search for "Move Your Data In
Real-time From MySQL To PostgreSQL And Greenplum".

In a nutshell, it looks like this:
(1) Manual work to prepare the empty schema on PG
(2) New MySQL instance with Row Replication enabled
(3) Dump your MySQL backup to this MySQL with Row Replication
(4) Tunsgten Replicator will extract all incoming Row Change Events of each
transaction and apply them to PG one by one, taking care of DBMS specific
conversions under the hood (there are quite a bit).

Hope this helps,

Sincerely,
Linas