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?
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.
Faced the problem a few years ago, and used pg2mysql
EDIT 21 july 2019 : this fork seems a better option (patches, light maintenance)
You can use the MySQL Workbench which can import from a variety of database types, including Postgres.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With