Skip to content

Instantly share code, notes, and snippets.

@back-2-95

back-2-95/migrate.load

Created March 16, 2024 09:43
Show Gist options
  • Save back-2-95/55cb48adb989e61c76b675be0e5563a9 to your computer and use it in GitHub Desktop.
Save back-2-95/55cb48adb989e61c76b675be0e5563a9 to your computer and use it in GitHub Desktop.
Download ZIP
Pgloader load file for migrating from PlanetScale MySQL to Neon PostgreSQL
Raw
migrate.load
LOAD DATABASE
FROM mysql://MY_PLANETSCALE_USERNAME:MY_PLANETSCALE_PASSWORD@aws.connect.psdb.cloud/MY_DATABASE?sslmode=require
INTO postgres://MY_NEON_USERNAME:endpoint=ep-MY_ENDPOINT_ID;MY_NEON_PASSWORD@ep-MY_ENDPOINT_ID.eu-central-1.aws.neon.tech/MY_DATABASE?sslmode=require
WITH include drop, create tables, quote identifiers
ALTER schema 'MY_DATABASE' rename to 'public'
;
@back-2-95
Copy link
Author

Running the migration:

/usr/local/bin/pgloader migrate.load

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment