Migrate PostgreSQL database to MySQL

Question

Say that I want to migrate a PostgreSQL database on Heroku to MySQL on EC2 and I need to preserve the ID values in all the tables, what's the best way to accomplish that without using paid software?

John Beynon · Accepted Answer · 2011-04-05 18:54:51Z

2

It's quite simple.

I would have mySQL instance locally, heroku db:pull to get it from Heroku Postgres to your local development mySQL instance, back it up and then restore the backup to your EC2 MySQL instance

answered Apr 5, 2011 at 18:54

John Beynon

37.5k8 gold badges92 silver badges97 bronze badges

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

2 Comments

Bob Over a year ago

I'm guessing heroku db:pull preserve the ID values even if they are pulled into a different type of database? If so, then this is a winner.

John Beynon Over a year ago

yep, it uses TAPS behind the scene, works very well - just watch out sometimes if you've done some DB specific sql that it may break going over to another DB platform.

Collectives™ on Stack Overflow

Migrate PostgreSQL database to MySQL

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related