Hi to all! I have a simple question regarding converting a postgresql database dump file to MySQL file, is there software to convert the files?

Your help is much appreciated,


Thanks and Regards,
Len

whats the format of the file
is it SQL or is it native POSTGRES?
It may be better to use a tool such as the MySQL import programme which can handle most db formats and insert the data into MySQL .. for get the name of it, its part ofd the MySQL GUI toolkit if I remember correctly

Hmmm. Seems like a backwards step.

Anyway, a postgresql dump can be configured as a standard text file output, containing the script to recreate the database and/or data. You also need to explicitly specify that inserts are used to insert the data, rather than the faster copy command.

After the dump has occurred, you'll need to manually adjust the SQL, as there are some differences, and as Postgresql has quite a few more features, there may be unsupported features that may nee adjustment.

That's what I though as well
Who would want to convert a Postgres DB into a MySQL DB

someone who has been told to do so by his boss

someone who is moving his website to a new host that doesn't support postgresql

someone who is tired of not getting help fast enough from experienced postresql practitioners and wants to go play in a much larger pond

someone who ...

oh, heck, you get the idea

That someone is surely not posting the questions to the PG mailing list

Sure I do, it was more meant as a joke (but with a little truth in it...)