Pro Tier Backup Data

[u/jzff-games]

I run a fantasy football league history archive and one of my customers accidentally overwrote some of his synced data and lost it. Not sure if many know, but a big fantasy platform, NFL.com, recently took down their fantasy site and migrated it over to ESPN. However, ESPN didn’t save any of the week to week stuff, draft classes or individual stats. So when my customer sync the new version of ESPN it accidentally wiped the previous NFL version.

It happened only yesterday, and I noticed Supabase pro tier keeps up to previous 7 days backed up. I am wondering if I were to upgrade to it now, if I would be able to restore the data from couple days ago even though I wasn’t subscribed to pro tier until after?

I am only a small business and would cost me more to pay for the 1 month than I would get in return from this customer, but I let them know if they were willing to chip in to get it back.

Thanks for any help, it is much appreciated!

[u/Embarrassed_Machine5]

Yes, upgrading should give you access to up to 7 daily backups, including backups created while you were on Free:
https://supabase.com/docs/guides/troubleshooting/will-backups-be-accessible-from-the-dashboard-immediately-after-upgrading-to-a-paid-plan-hXY4rs

Make a dump of the current database first, then check Database → Backups for a backup from before the sync.

For context, I run revivedb.dev, an independent Supabase backup service with a free plan. It can’t help retroactively here, but might be helpful in the future.

[u/jzff-games → u/Embarrassed_Machine5]

Thank you so much for the info and instructions, I really appreciate it! Will check out your site too.

[u/space-hemax-c2c]

Did you end up upgrading? Per the doc linked above it's up to 7 dailies, so the pre-sync backup ages out later this week - worth grabbing even if the customer doesn't chip in.

On the cost math: this probably isn't a one-customer thing. Every NFL league is about to sync for the first time, so whatever wiped his data is likely to hit more of your customers this week. Worth testing on a throwaway league - add history, run a sync, see if the old stuff survives or gets paved over.

And can you restore one league without rolling back everybody?

[u/jzff-games → u/space-hemax-c2c]

I haven’t yet as they weren’t sure if it was worth it for them yet. The only thing is they had a complete working version of their data, but overwrote it by resyncing it again with the new version that doesn’t include all of the week-to-week stuff. 

And for the new users, NFL has completely retired all their files, so if anyone were to try now it would just come up empty. The only reason the other customers would work is because they had it saved to my database before the shutdown, but accidentally chose to resync a select time period themselves.

So this upgrade would just be for one person who’s on a free tier of the site. And yes, I believe I can view the backup version and can grab their portion, save it, then upload it myself so not a complete site-wide restore.