2011/2/22 Adarsh Sharma <adarsh.sha...@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> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
