Migrate database from Postgres to MySQL

Question

I have changed database from PostgreSQL to MySQL, but I don't know how to transfer data to MySQL.

Does anyone know any command by which I can copy/migrate my database from PostgreSQL to MySQL?

Frosty Z · Accepted Answer · 2012-07-24 08:25:22Z

up vote 18 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.

answered May 6 '11 at 9:15

Frosty Z
9,80943660

3

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

add a comment |

Deckard · Answer 2 · 2013-02-25 13:03:27Z

up vote 7 down vote

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

answered Feb 25 '13 at 13:03

Deckard
1,191621

add a comment |

2 Answers 2