N
Neon•2y ago
fair-rose

Migrating From Planetscale

Hi, I am trying to migrate our MySQL database on PlanetScale to Neon (heard great things). I found this: https://neon.tech/docs/import/migrate-mysql When I run pgloader I get this 
$ pgloader config.load

2024-03-09T21:07:35.004779-05:00 LOG pgloader version "3.6.9"
2024-03-09T21:07:35.005881-05:00 LOG Data errors in '/private/tmp/pgloader/'
2024-03-09T21:07:35.005916-05:00 LOG Parsing commands from file #P"/Users/***/Desktop/config.load"
KABOOM!
DB-CONNECTION-ERROR: Failed to connect to pgsql at "***.us-west-2.aws.neon.tech" (port 5432) as user "***": Database error XX000: Console request failed
An unhandled error condition has been signalled:
   Failed to connect to pgsql at "***.us-west-2.aws.neon.tech" (port 5432) as user "***": Database error XX000: Console request failed

What I am doing here?

Failed to connect to pgsql at "***.us-west-2.aws.neon.tech" (port 5432) as user "***": Database error XX000: Console request failed
$ pgloader config.load

2024-03-09T21:07:35.004779-05:00 LOG pgloader version "3.6.9"
2024-03-09T21:07:35.005881-05:00 LOG Data errors in '/private/tmp/pgloader/'
2024-03-09T21:07:35.005916-05:00 LOG Parsing commands from file #P"/Users/***/Desktop/config.load"
KABOOM!
DB-CONNECTION-ERROR: Failed to connect to pgsql at "***.us-west-2.aws.neon.tech" (port 5432) as user "***": Database error XX000: Console request failed
An unhandled error condition has been signalled:
   Failed to connect to pgsql at "***.us-west-2.aws.neon.tech" (port 5432) as user "***": Database error XX000: Console request failed

What I am doing here?

Failed to connect to pgsql at "***.us-west-2.aws.neon.tech" (port 5432) as user "***": Database error XX000: Console request failed
I tried doing it when my connection status was active, and I have the endpoint ID in the connection string. I think many people are probably in the same boat here trying to migrate of PS, so a blog post or doc page on how to do this for everyone will be incredibly useful! Thanks for the help!
Neon
Migrate your MySQL database to Neon Postgres - Neon Docs
This topic describes how to migrate your MySQL database to Neon Postgres using pgloader. The pgloader utility transforms data to a Postgres compatible format as it is read from your MySQL database. It...
1 Reply
afraid-scarlet
afraid-scarlet•2y ago
Hey, here's the config.load file I used in a successful migration test from PS (user/password removed) load database from mysql://user:password@aws.connect.psdb.cloud/db-test?sslmode=require into postgresql://daniel:endpoint=ep-noisy-wind-a5cp63dd;password@ep-noisy-wind-a5cp63dd.us-east-2.aws.neon.tech/neondb?sslmode=require; Make sure your Neon user is the owner of your Neon database (the user that created the database). Thread on the same topic: https://discord.com/channels/1176467419317940276/1197250879645036664/1197313781185904701

Did you find this page helpful?