Port a MySQL database to PostgreSQL

In North America, people are enthusiastic about PostgreSQL. With the development of postgresql, PostgreSQL 8.x has already surpassed MySQL 5.x technically, and market transcendence is only a matter of time. In the end, users may have the opportunity to enjoy open-source databases comparable to Oracle.
The Internet company I work for serves about 0.5 million business users. After many upgrades and transplantation, the company has all migrated backend databases from MySQL to PostgreSQL, I have completed half of the database migration, so I have accumulated some experience in migrating databases from MySQL to PostgreSQL. I am going to write it here, hoping to inspire everyone to use PostgreSQL.
1) preparation: Use the Mysql Data Backup Tool for full backup of the database:
Mysqldump-H [hostname]-U [username]-P [Password] -- extended-insert = false [dbname]> mysql-db. SQL
Note: Disable extended-insert. PostgreSQL does not support extended-insert of MySQL.
2) Conversion : Convert mysql-db. SQL to SQL script that PostgreSQL can import.
MySQL and PostgreSQL have some differences in SQL semantics. For example, MySQL does not support sequence, trigger, and other functions. However, it provides some proprietary syntax rules and compares some system functions, there is a big difference between MySQL and PostgreSQL. For this reason, I have compiled a semantic analysis and conversion Program Mysql2psql
> Mysql2psql mysql-db. SQL postgres-db. SQL
3) Import : Use pgadmin provided by PostgreSQL to import data files to the database.
4) SQL statement Modification : In practical applications, front-end systems often embed some SQL statements with database features. As the background database changes, front-end system programs also need to be modified accordingly.
The most common differences between MySQL and PostgreSQL include group by, join usage, and system function naming and calling.