up vote -1 down vote favorite
share [g+] share [fb]

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

link|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
feedback

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

This question came from our site for professional and enthusiast programmers.

2 Answers

up vote 6 down vote

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

link|improve this answer
feedback
up vote 0 down vote

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/

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard