0

I'm trying to get migrate data from a postgre db into mysql (mariaDB) and was wondering if it is possible to restore a db in mysql from a pgsql dump?

Dark Star1
  • 1,385
  • 7
  • 22
  • 37

1 Answers1

1

No, it isn't.

You need to do a --schema-only dump and hand-convert the schema, then do a --data-only --inserts dump and use a text-processing tool to remove/replace any PostgreSQL-specific code.

Alternately, use an ETL tool like Pentaho Kettle or Talend.

Craig Ringer
  • 11,083
  • 9
  • 40
  • 61
  • Although not perfect: http://www.lightbox.ca/pg2mysql.php did most of the job for me. I have to do some handwork but this is the closest thing to a tool that I can find atm. – Dark Star1 Jan 24 '13 at 02:02