Convert PostgreSQL dump file to MySQL?

Question

Do I want to convert a PostgreSQL dump file that I received to a MYSQL dump file or even sql text to be generated?

Answer 1

If you are installing PostgreSQL client programs, you can use "pg_restore" to convert the dump file to an SQL script without having to have a PostgreSQL instance. Just do pg_restore dumpfile.pg and it will return the SQL recovery file to standard output.

Answer 2

If you have PostgreSQL installed on your terminal and your latest.dump file, you just need to convert it to latest.sql as follows:

$ pg_restore latest.dump > latest.sql

Answer 3

Check out this link ... maybe help

http://www.weberp.org/HowToConvert

Also check the links

http://dbconvert.com/convert-mysql-to-postgresql-pro.php

https://stackoverflow.com/questions/1884060/is-there-a-free-tool-to-convert-mysql-dump-to-postgres

Answer 4

A google search provided a link to this discussion . He looks encouraging, and perhaps this will help.

NTN