NeonN
Neon•2y ago•
1 reply
significant-gray

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


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...
Migrate your MySQL database to Neon Postgres - Neon Docs
Was this page helpful?