Convert PostgreSQL dump to MySQL

If you have a PostgreSQL database dump file and want to import to your MySQL database, then first download and install this conversion tool..

If the dump conversion fails, then recreate the dump file in a more compatible format like so..

pg_dump dbname --inserts --format p -f /tmp/newpgdump.sql

If you don't have the original postres db then first create it by importing the dump file..

psql dbname < /tmp/pgdump.sql

Then create a new dump file as above.

Now convert the new dump file to mysqldump..

php pg2mysql_cli.php /tmp/newpgdump.sql /tmp/newpgdump_mysql.sql

Then import it to mysql in the usual way..

mysql -u root -p dbname < /tmp/newpgdump_mysql.sql

Tips: you may need utf8 working in mysql - check these exist in my.cnf if so..

default-character-set = utf8

default-character-set = utf8
default-collation = utf8_general_ci


Looking for great online sysadmin training in Linux, Security & Hacking and many others?