So I woke up this morning, and some key data is just gone from my app. We have an entire ERP built in bubble.io and for example complete companies and their information are compeltely gone from the database.
My first question is there any way to get that data back and my second question is if anyone else is having this issue?
Haven’t come across this before but Bubble gives you the provision to restore your data to a point in the past
Hey Brian! Bubble has a restore data feature where you can set your whole database back in time. Unfortunately this is an all or nothing kind of thing where you wouldnt be able to select a certain user or filter out what data you want to restore.
You can find more information here Restoring database backups | Bubble Docs
I recommend reaching out to bubble support and looking at your logs as well to see if maybe it was user deleted.
I do recommend implement soft delete in bubble (Archived field) or something similar in the future to prevent this
Thanks for the quick response. I tried using the restore data feature and the data is still missing.
I tried using the restore data feature and the data is still missing. It looks like the data was deleted in the last hour or so. I actually don’t have a way to users to delete companies, which is why this is even stranger.
Are you maybe looking in the dev database and not the live one?
Unfortunately, Im looking at the lIve database.
Hmm thats very strange. The data restore feature, if the right fields selected will always restore all the possible data.
I recommend reaching out to bubble support. Without looking into your app further its hard to tell.
I turns out I was not restoring far enough back. The missing data was only in one specific data type. I was wanting to just restore that single data point, but Im assuming that wont work because anything that had a relationship to it will still be missing that info even after I restore correct? So I will need to restore all data types, am I correct?
No, as long as you restore it back to a certain period backward, it will go back and undo any changes that was done after that selected period of time(date)
I feel like this is a great spot for https://planbbackups.io/ if you havent heard of it.
