2011/2/22 Adarsh Sharma <adarsh.sharma@orkash.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>