Converting a postgresql database to mysql?

Question

I've been a'Googling and there's all sorts of various forms of crazy ideas out there, but, dear Stack Overflow geniuses, is there a stable, reliable form of converting a postgresql database to a mysql database on Linux?

Answer 1

You can write a program which connects to both databases and reads records from PostGres, inserting to MySQL. You'll have to do the schemas by hand.

This is a pretty common way to do database migrations... An automated tool would be nice, but the differences in functionality are so subtle that I'm not sure one exists.