Importing records from PostgreSQL to MySQL

Question

Was wondering if anyone had any insight or recommended tools for exporting the records from a PostgreSQL database and importing them into a MySQL database. I believe the table structure is 100% identical.

Thoughts? Thanks!

Matthew Wood · Accepted Answer · 2011-04-21 15:33:24Z

26

The command

pg_dump --data-only --column-inserts <database_name>

will generate SQL-standard-compliant INSERT statements with all column names listed and one VALUES clause per INSERT. This is the most portable way of moving data from PostgreSQL to any other SQL database.

answered Apr 21, 2011 at 15:33

Matthew Wood

16.5k6 gold badges49 silver badges35 bronze badges

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

1 Comment

rxgx Over a year ago

Before you import the SQL file into your database, run a [bundle exec ]rake db:migrate to create the tables and columns.

fvu · Accepted Answer · 2011-04-20 21:52:59Z

5

Check out SquirrelSQL, it can pump data from one database brand into another via the DBCopy plugin. When the table structures are really identical it works quite well.

answered Apr 20, 2011 at 21:52

fvu

33.1k6 gold badges64 silver badges84 bronze badges

Comments

eggie5 · Accepted Answer · 2011-04-20 21:53:27Z

3

There is a ruby app called Taps that will do it. I've used it before with great success:

http://adam.heroku.com/past/2009/2/11/taps_for_easy_database_transfers/

answered Apr 20, 2011 at 21:53

eggie5

1,96018 silver badges27 bronze badges

Collectives™ on Stack Overflow

Importing records from PostgreSQL to MySQL

3 Answers 3

1 Comment

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Linked

Related