-- See https://github.com/dimitri/pgloader/blob/master/pgloader.1.md for 
-- connection string options.

LOAD DATABASE
    FROM mysql://root@localhost/base_photo_app
    INTO postgresql:///base_photo_app

-- data-only: We don't need pgloader to touch the schema as Rails does a better
--            job using rake db:schema:load.
-- truncate:  Ensure all tables are empty first (especially schema_migrations).
--            WARNING: THIS WILL SMOKE YOUR DATABASE!

WITH create no tables, disable triggers, preserve index names, truncate;