Jim C. wrote:
You probably want one of the mysql converter projects, e.g.
http://pgfoundry.org/projects/mysql2pgsql/
Also read the "converting from other databases" section here:
http://www.postgresql.org/docs/techdocs
I tried several conversion tools and did get some minor success with one
or two but mostly they didn't work. The article at this site seems good
at first blush but then one notices that it doesn't seem to have been
updated any time in the last five years.
I have to admit it's been at least a couple of years since I've used any
of the mysql2pg scripts.
--
Richard Huxton
Archonet Ltd