Move data from PostgreSQL to MySQL database [duplicate]

Question

I have a PostgreSQL database with 50 tables which I need to export then import it in MySQL database. I need to maintain same table fields, data inside tables.

I am using pgAdmin III, tried using the Backup (Plain) feature but couldn't then import data and tables in mysql

I have also tried searching the web on how to do so but failed to locate any useful info so any help is highly appreciated.

Thanks

@Precious1tj I've tried the answer for this question but it didn't work :( I simply got many errors during the import operation in MySQL for the sql file. — MChan
– MChan, Commented Aug 30, 2013 at 22:11

Vlad · Accepted Answer · 2013-08-30 21:33:16Z

0

Take a look at http://www.mysql.com/products/workbench/ It has a Migration Wizard.

answered Aug 30, 2013 at 21:33

Vlad

9786 silver badges13 bronze badges

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

2 Comments

MChan Over a year ago

I've tried using MySQL migration toolkit but unfortunately the tool doesn't support importing from Postgresql! :(

Vlad Over a year ago

Are you sure you had the latest version? On the page I linked to it mentions PostgreSQL as a supported DB.

Collectives™ on Stack Overflow

Move data from PostgreSQL to MySQL database [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related