convert the db:
if you're using linux on the postgres server, first dump the postgres db:
pg_dump -d databasename > dump.dmp
now look into dump.dmp. it contains the (postgres) sql statements you need to rebuild your entire database, including data.
modify the postgres sql script so it would run under mysql - perhaps you'll have to correct datatype names etc.
create the new mysql database. open a mysql shell. execute the sql script using the dot command:
source (.) Execute a SQL script file. Takes a file name as an argument.
perhaps it won't run at once. but it will thell you which the errors are. after a bit of adapting, you'll get the script running and your db set up.
hth!
