Export from Postgres to MySQL

[bundschuh]

Hello,

I have some data in a Postgres-DB and I have to import some of them in a MySQL-DB. In my mind, there are 2 ways to do this:

1. Export the whole Postgres-DB into a emtpy MySQL-DB and then pick out the data I need via PHP, etc.

2. Pick out the data directly from the postgres-db into specific mysql-tables, rows.

So far the theoretical part. BUT:
How to realize that?
Any ideas?

Regards,

Philipp