SupabaseS
Supabase•5mo ago
YG400

**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 vanished
Was this page helpful?