Consider creating MySQL to PostgreSQL data migration tool

I just finished migrating all of the data from a MySQL database to a PostgreSQL database, but ran into quite a few hiccups along the way.

Using the mysqldump method documented in the [Migrate MySQL to PostgreSQL]( guide that lead to quite a few warnings and errors, such as:



This is particularly an issue with place names that had embedded inverted single quotes.

Using the CSV export and import method led to a lot of issues where page names had embedded double quotes.

I had to hodgepodge the CSV method along with using DataGrip to import data for the user table due to the following PostgreSQL query error:



Since PostgreSQL is required with version 3 onwards, a proper migration script or tool should be written where the user provides the source and destination connection strings and the tool handles copying over the data. Otherwise, you may have unhappy self-hosters out there.