Wiped production DB by mistakes, any options?
Unanswered
Tonkinese posted this in #help-forum
TonkineseOP
So i kinda f'd up,
here is how it went,
i ran prisma migrate dev on production by mistake, realizing this mistake, i immediately control c'd task,
at this point i did not think this would cause whole db to be wiped, so i continued as nothing had happen,
but the server was constantly erroring, wondering why i looked to vercel storage (where i hosted my db)
i saw no tables there, i panicked and very stupidly ran prisma db push
and so now i have no db and probably no job in a few days time
is there any option? please i would really appreciate even a bit of help
here is how it went,
i ran prisma migrate dev on production by mistake, realizing this mistake, i immediately control c'd task,
at this point i did not think this would cause whole db to be wiped, so i continued as nothing had happen,
but the server was constantly erroring, wondering why i looked to vercel storage (where i hosted my db)
i saw no tables there, i panicked and very stupidly ran prisma db push
and so now i have no db and probably no job in a few days time
is there any option? please i would really appreciate even a bit of help
11 Replies
@joulev do you have any database backups?
TonkineseOP
it was on vercel storage, and i dont think they keep backups
@Tonkinese it was on vercel storage, and i dont think they keep backups
do you have a pro/enterprise vercel account
@joulev do you have a pro/enterprise vercel account
TonkineseOP
no, hobby
so restoring from backups isn't an option. i'm not an ace in prisma so i'm out of options here, you can try asking for help in prisma forums https://www.prisma.io/support to see if there is any way to savage any data
since you dont have a paid vercel plan, you cannot contact support for this issue, so i suggest you also post in vercel discussions https://github.com/orgs/vercel/discussions which is the support forum for your plan
but still you should probably still use https://vercel.com/help and submit a customer support case of highest severity and hopefully they allow you to do it
this is what chatgpt suggests
TonkineseOP
i am unable to create case as i have a hobby plan, i have posted this on vercel discussion and prisma's discord, now hoping for the best
best of luck, hope you can recover it somehow