MySQL to PostgreSQL Converter

Lanyrd's MySQL to PostgreSQL conversion script. Use with care.

This script was designed for Lanyrd's specific database and column requirements, and made a bit more generic in this fork.

Places indexes on all foreign keys. Some binary / blob data throws UTF-8 conversion errors on import (TODO).

How to use

First, dump your MySQL database in PostgreSQL-compatible format

mysqldump --compatible=postgresql --skip-triggers --default-character-set=utf8 -r databasename.mysql -u root databasename

Then, convert it using:

python mysql2psql.py databasename.mysql databasename.psql

It will print progress to the terminal.

Finally, load your new dump into a fresh PostgreSQL database using:

psql -f databasename.psql