Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Can I convert a PostgreSQL dump file into a MySQL dump? I tried but I get syntax error.

cd "C:\Program Files\MySQL\bin"
mysql -u root -proot 

I run this batch file after I put this

 --compatible=postgresql <mysql.sql
share|improve this question
You said you did not get syntax error. Does it work for you? –  Khaled Jun 10 '12 at 11:12
What exactly did you do and how did it not work as expected ? –  Iain Jun 10 '12 at 11:36
i just read and try to implement it –  Pavan Gomladu Jun 10 '12 at 11:37
like below cd\ c: cd "C:\Program Files\MySQL\bin" mysql -u root -proot pause after that i write the syntax like compatible=postgresql < mysql.sql –  Pavan Gomladu Jun 10 '12 at 11:38
Pavan please edit your question to show the exact steps you undertook. –  Iain Jun 10 '12 at 11:43

Your Answer


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

Browse other questions tagged or ask your own question.