Connection string has changed and can't access database on neon dashboard.
Hello, I tried to creat a new account on neon.tech with my different email but it was actually connected to my first account which was created with my github account, so it overwrote my database and all the tables are wiped on the dashboard.
However, I can still connect my app to the first database using the original connectionstring. I am using prisma studio so I can see the table items using their service, but I cannot see my table contents via neon.tech.
Could anyone help me with this?
9 Replies
absent-sapphire•2y ago
Hey! Sorry to hear that you're running into an issue.
To make sure I understand correctly, you:
1. Created an account using GitHub
2. Tried to create an account with the same email as your github email
3. Now the two accounts are connected but you have a new project with a different connection string?
What happens if you try to log out and then login with GitHub again?
like-goldOP•2y ago
It is not really an issue with login/logout.
I will make it more detail about what i have done.
1. creatd neon database on neon.tech using my gmail.
2. realized that I have left the database running overnight on free acount -> branches except main died. so, i tried to create new neon account using github account to use the branching function.
3. However, the first account already had my gmail and github (I dont know why) so evern though i login with github account, it takes me to the first account (with gmail) where the previous database has already been wiped (since i was asked to create the new database first time I signed up with my github account although it took me to the first account's dashboard afterwards)
4. Now, i can use data in the first database using connection string that i remembered, but I can't see data/tables on neon.tech dashboard, and the connection string to the current database is different. Also, although i dont see data on my dashboard, the but database accumulates the running time. So i think it still recognizes my first database being used
absent-sapphire•2y ago
Does your GitHub account use the same email as your gmail?
like-goldOP•2y ago
yes
absent-sapphire•2y ago
Hmm, then the two accounts should've been linked together I think
Do you mind sharing the compute endpoint ID of the connection string that has data? it's the part of the hostname and has
ep- then a bunch of wordslike-goldOP•2y ago
this is the id that's being actually used
ep-billowing-cloud-a4er4r0m
and this is what I see on my dashboard right now (under both accounts)
ep-quiet-boat-a4oovnej
absent-sapphire•2y ago
ep-billowing-cloud-a4er4r0mThis project belongs to an @yahoo.com email.
ep-quiet-boat-a4oovnejSame email as the @yahoo.com one but it's gmail so they're two different accounts
absent-sapphire•2y ago
To unblock you, you could migrate the data that's under one project to the other by following this guide https://neon.tech/docs/import/import-from-neon
You just need to have psql installed (comes with a Postgres installation)
Neon
Import data from another Neon project - Neon Docs
This guide describes how to migrate a database from one Neon project to another by piping data from pg_dump to pg_restore. Use these instructions to Import a database from a Neon project created in on...
like-goldOP•2y ago
Ahhhh I see
Ok thank you for the help