On 8/4/06, Gilbert T. Gutierrez, Jr. <plug@phxinternet.net> wrote:

I am not that familiar with PostGreSQL and made a mistake in selecting it
for this application.  I can, I am sure move the data.  The issue is the
time it will take me.  Someone that is familiar may be able to do this
quicker than me.  The app also has a way to export data and then re-import
it that I may end up using, I am just not comfortable that it will export
all data.

You can move data either way using the dump commands.

For instance:

1) pg_dump -U postgres -D mydb > mydb.sql
(-D makes extended inserts)
2) mysql -u root newdb < mydb.sql

Please watch closely for errors. It is possible you'll need to edit the table definitions (data types) when converting from 1 DB to another. If you are using foreign keys you'll need to be careful to select a backend data type in MySQL that supports this.