Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Migrate database from Postgres to MySQL [closed]

I have changed database from postgresql to mysql, but I don't know how to transfer data from one to other.

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

like image 618
Sachin R Avatar asked May 06 '11 09:05

Sachin R


People also ask

Will PostgreSQL overtake MySQL?

PostgreSQL is still catching up to MySQL's popularity, which means that fewer developers are working with it and fewer third-party applications are available. However, with the increasing need for highly concurrent services that are always available, Postgres might soon overtake MySQL as the most popular database tool.


2 Answers

Faced the problem a few years ago, and used pg2mysql

EDIT 21 july 2019 : this fork seems a better option (patches, light maintenance)

like image 94
Frosty Z Avatar answered Oct 13 '22 03:10

Frosty Z


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

like image 19
Deckard Avatar answered Oct 13 '22 04:10

Deckard