Transfer data from PostgreSQL to MySQL

Question

Hello is there any method to transfer the table layout and data from a Postgres database to MySQL automatic?

I have to migrate the scheme anda data to MYSQL

Jon · Accepted Answer · 2011-09-11 14:10:46Z

5

The easiest would probably be to export the database (schema & data) as SQL using Postgres' pg_dump utility, then import the resulting SQL file into MySql.

It's possible that there will be some incompatibilities in the intermediate SQL, but you can almost assuredly take care of these with a find/replace in your favorite text editor.

answered Sep 11, 2011 at 14:10

Jon

439k85 gold badges756 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

electroid Over a year ago

More details about export how to export values from PostgreSQL can be found here stackoverflow.com/a/5746348/1078641

Nikita Volkov · Accepted Answer · 2012-11-26 14:12:59Z

0

It is possible to do using the "Data Transfer" feature of Navicat Premium. It will not preserve foreign keys though, but the data transfers correctly with the two databases incompatibility issues resolved.

answered Nov 26, 2012 at 14:12

Nikita Volkov

43.4k12 gold badges98 silver badges172 bronze badges

Collectives™ on Stack Overflow

Transfer data from PostgreSQL to MySQL

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related