Migrating PostgreSQL data to MySql

I have some problems migrating data from 29 tables in postgres to mysql. I know roughly that you can do this in a particular way from mysql to postgres but haven't found otherwise.

I know you can write some php script to retrieve and re-insert from postgres to mysql but that sounds like manual work. I was hoping to find some 'conversion'/API, utility for me to do this.

Any ideas?

Thanks.

I doubt that you'll find an automated conversion utility/API because there are number of features that PostgreSQL supports that mySQL doesn't (eg. named procedures).

If you are just interested in exporting the data and basic table structure from one to the other, your best option is probably to explore the "dump" command that both mySQL and postgreSQL have. This will create SQL needed to make your tables and populate them with data. You may need to modify the dumped file to account for any minor differences between mySQL and postgreSQL syntax.

Hadley