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.
+4
A:
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:
/Allan
Allan Wind
2008-09-21 00:18:52
The problem with pg2mysql: cutting and pasting an 800MB text file into a browser and posting it remotely.The other problem with pg2myql: downloading the source and running it locally, and passing an 800MB string into the converter.
James D
2009-07-10 14:35:14
A:
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.
Tometzky
2008-09-22 12:28:03
+1
A:
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.
Grant Johnson
2008-09-22 18:39:11