I need to convert a POSTGRESQL database over to MYSQL due to hosting restrictions… recommendations?
OK. I run a drupal site, and just for fun I set it up to use postgresql, because my hosting provider provided it.
Now I’m moving to another provider that does not provide postgresql, and I need to convert databases. Recommendations? Preferably a process that doesn’t require "write a sql script by hand (or a database parser) to replace the other database"
Have you tried the MySQL Migration Toolkit?
Its part of the GUI tools package:
http://dev.mysql.com/downloads/gui-tools/5.0.html


Have you tried the MySQL Migration Toolkit?
Its part of the GUI tools package:
http://dev.mysql.com/downloads/gui-tools/5.0.html
References :