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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
