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