MySQL to PostgreSQL migration - netfishers-onl/Netshot GitHub Wiki

Create the migrate.load file:

LOAD DATABASE
    FROM mysql://user:pass@sourcehost/netshot01
    INTO postgresql://netshot:pass@localhost/netshot01
WITH include no drop, create no tables, create no indexes, reset sequences,
    batch rows = 10, prefetch rows = 10
ALTER SCHEMA 'netshot01' RENAME TO 'public';

Run the migration using pgloader:

$ pgloader migrate.load