Database got overwritten

I created a new Postgres table which I connected to from a new project of mine. But it seems that the data from the new project went to a table from another project instead, overwriting the info there. Is there a way to recover it?
14 Replies
Percy
Percy6mo ago
Project ID: N/A
SunkCapital
SunkCapital6mo ago
ddb679c5-f702-4fde-a536-0e605ee4c108 I don't understand how using ecb0b1f5-d32e-43be-b8a0-2e6b56859001 database URL got to overwrite the data in the one above.
Brody
Brody6mo ago
did you have a backup?
SunkCapital
SunkCapital6mo ago
No
Brody
Brody6mo ago
and what makes you think the database got overwritten?
SunkCapital
SunkCapital6mo ago
Accessing ddb679c5-f702-4fde-a536-0e605ee4c108 shows a model from another project of mine and all the previous data and models are gone.
Brody
Brody6mo ago
please connect to the database with a proper database client like dbgate
SunkCapital
SunkCapital6mo ago
how would that help?
Brody
Brody6mo ago
I wouldn't trust anything the data tab says
SunkCapital
SunkCapital6mo ago
But the website is down so the data is missing for sure and I don't understand how this happened
Brody
Brody6mo ago
are you connecting to the correct database?
SunkCapital
SunkCapital6mo ago
I did not touch the code in deleted data project. The table there seems to have been killed when I created a new project. I thought I might have used the wrong database_url by accident but I checked and that wasn't the case. So I am not sure how the data died
Brody
Brody6mo ago
I'm sorry, I don't know what to tell you besides that going forward please look into taking a backup of your data
Adam
Adam6mo ago
Please check your data using a database client, as Brody said Just because your website is down, doesn't mean the data is gone