**URGENT HELP NEEDED** I think i delete/reset all the data from by database
Hey all! I'm in serious trouble and could really use your help
What happened: I completely messed up my production database today trying to add a referral system
So basically I was running
-
supabase db push to add some new tables for referral codes, and it hit some migration conflicts. Instead of backing out, the migration process seems to have just... deleted/reset my entire production database
What I lost:
- food_categories - had like 20+ food categories
- food_items - THOUSANDS of food items with detailed nutrition data
- restaurants - 25+ restaurant chains-
restaurant_items - THOUSANDS of menu items
This isn't just some test data... this is literally MONTHS of work. I spent weeks manually researching and entering nutritional data, protein quality scores, digestibility ratings - all of it is gone. My app "Brotein" is basically dead without this data.
Current situation:
- Only the new referral tables exist now (access_codes, etc.)
- All my core production data is completely wiped
- My Supabase Storage is fine (thank god) - all the food images are still there
- I'm on free plan so no backups 😭
- No local exports because I'm an idiot
The ask:
I know I'm on free plan but I'm literally willing to upgrade to Pro RIGHT NOW if you can help me recover this. Do you guys have any point-in-time recovery or transaction logs that could save me? Even getting back like 50% of the data would be a miracle.
This is my production app with real users and I'm honestly panicking right now. The migration was just supposed to add new tables but somehow nuked everything else.
Please tell me there's something you can do 🙏🙏🙏
Would massively appreciate any help - this represents months of my life that just vanished2 Replies
If you go to pro plan users have said you get 7 daily backups from the past days. $25 minimum commitment for the month and this is not documented so a very low risk it might not be true now. But many have done this.
As far as "you can do"... no user here can recover your data as postgres itself has nothing built in. So backup is required.
If you go back to free you should still do your own backups with 3rd party tools.
@garyaustin thank you man. Im going to try that right now then let you know what happens
^you are a freakin godsend. I got it back thank you