24.1. Migrating from MySQL to PostgreSQL
MySQL databases are in widespread use among Web developers. Although MySQL lacks many functions provided by sophisticated database programs such as DB2, Oracle, PostgreSQL, or many others, people like MySQL because of its simplicity.
In this section, you will see how to migrate data from MySQL to PostgreSQL.
24.1.1. A Brief Installation Guide
The first thing is to get started with MySQL. We recommend downloading a binary version of MySQL. In this section version 4.0.1 has been used. You can easily install the package using the instructions in the manual.
After installing the binaries and starting the daemon, you can use the interactive shell to connect to the database:
[root@duron mysql]# mysql Welcome ...Get PHP and PostgreSQL: Advanced Web Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
