CODEWITHSUNDEEP
mysqlpostgresql
thesmallprint
thesmallprint

Reputation: 2391

Converting PostgreSQL database to MySQL

I've seen questions for doing the reverse, but I have an 800MB PostgreSQL database that needs to be converted to MySQL. I'm assuming this is possible (all things are possible!), and I'd like to know the most efficient way of going about this and any common mistakes there are to look out for. I have next to no experience with Postgre. Any links to guides on this would be helpful also! Thanks.

Upvotes: 3

Views: 10294

Answers (3)

user9706
user9706

Reputation:

One advise is to start with a current version of MySQL, otherwise you will not have sub-queries, stored procedures or views. The other obvious difference is auto-increment fields. Check out:

pg2mysql

/Allan

Upvotes: 6

Tometzky
Tometzky

Reputation: 23890

You should not convert to new database engine based solely on the fact that you do not know the old one. These databases are very different - MySQL is speed and simplicity, Postgres is robustness and concurrency. It will be easier for you to learn Postgres, it is not that hard.

Upvotes: 4

Grant Johnson
Grant Johnson

Reputation: 1244

pg_dump can do the dump as insert statements and create table statements. That should get you close. The bigger question, though, is why do you want to switch. You may do a lot of work and not get any real gain from it.

Upvotes: 2

Related Questions