Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 5 down vote favorite
1

Hello I have changed database from PostgreSQL to MySQL, but i don't know how to transfer data to mysql. Have anyone know any command by which i can copy/migrate my database from PostgreSQL to MySQL.

share|improve this question

2 Answers

up vote 8 down vote accepted

Faced the problem a few years ago, and used pg2mysql

If I remember well I had to fix one or two things, but works quite well.

share|improve this answer
1  
In my case it has not worked well in converting the COPY commands that are produced by exporting from postgres. – Peter DeWeese Jul 25 '12 at 17:28
up vote 1 down vote

You can use the MySQL Workbench which can import from a variety of database types, including Postgres.

share|improve this answer

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.