Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

How to restore postgreSQL backup file to MySQL server? I don't have postgreSQL server on my system. I have only MySQL server

share|improve this question
2  
super users might be a better place for this type of question. – wheaties Sep 28 '10 at 16:51
Please change the title of the question to reflect what is needed. – Levi Hackwith Sep 28 '10 at 16:52
@wheaties: +1 I agree, or serverfault. – Ryan Hayes Sep 28 '10 at 16:52
'Super Users' meaning this website: superuser.com – Lethargy Sep 28 '10 at 16:52
Terrible question....please re-edit and be consistent in your formatting... – t0mm13b Sep 28 '10 at 18:19

migrated from stackoverflow.com Sep 28 '10 at 16:53

2 Answers

Install PostgreSQL, restore from backup, export the schema and data then import into MySQL.

share|improve this answer

I agree with florin, while performing postgre-sql to mysql migrations, its best to export, rather than restoring from dumps.Please find in detail :

http://www.codesmell.org/blog/2009/03/migrate-data-from-postgres-to-mysql/

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.