将数据库从 Postgres 迁移到 MySQL

Question

提问by Sachin R

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

我已将数据库从postgresql更改为mysql，但我不知道如何将数据从一个传输到另一个。

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

有谁知道我可以将我的数据库从postgresql复制/迁移到mysql 的任何命令？

Answer 1

Faced the problem a few years ago, and used pg2mysql

几年前遇到过这个问题，用过pg2mysql

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

2019 年 7 月 21 日编辑：这个叉子似乎是一个更好的选择（补丁，轻度维护）

Answer 2

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

您可以使用MySQL Workbench，它可以从各种数据库类型（包括 Postgres）导入。

Answer 3

Dbeaveris the perfect solution for painless migration, column to column mapping, character encoding and also open source.

Dbeaver是无痛迁移、列到列映射、字符编码和开源的完美解决方案。