Hello everyone,
I was wondering if it’s possible to roll back the database to a specific date in the past and then roll it back to the current date. For example, today is September 5th, can I restore the database to July 11th to check for some missing data? After that, I want to revert back to the current state on September 5th.
Basically, I want to export the data from July 11 to an Excel file and manually enter some lost data into the current live database as of September 5. Is this possible?
Thank you very much! 
Selective restoration is unfortunately not possible in either dev or live dBs.
Depending on your plan I believe you can restore back to july 11, export relevant data and then restore to sept 5.
Thank you for your replies, but I’m confused because you gave me two different answers. @cmarchan, what do you mean exactly by selective restoration? And @code-escapee, have you ever done what I mentioned in my post? Thank you!
Yes I have. (Never manually updated the current DB but that shouldn’t male for a diff). @cmarchan is correct on selective restoration but you don’t needto selectively restore. Youd have to restore entire DB
This is possible @gabriel.guerin
But … going back and forth thus … “selectively” restoring … may not be possible as I understand. You can go to a previous version of the dB or of a data type. But… be careful as done wrongly may cause trouble.
Hey, thanks for your responses @cmarchan and @code-escapee. I think there has been a misunderstanding. I’m not trying to restore a specific type of data. What I want to do is restore the entire database to a specific point in time, export that data (or some specific data types) to an Excel file, and then restore the database to its current state (i.e. today’s date).
I hope this will help me avoid losing any data. My main goal is to have an Excel file of the data from the past so I can find what was deleted.
I see in the Bubble application that I can restore it back to 365 days ago. But if I restore it to July 11th, will I be able to restore it to what it is today? Thank you.
I understood that to be your question from the get go so my responses above are to with regard to that question.
Everyone on this post is correct @cmarchan @code-escapee 
The problem with reverting your app to a point in time, quickly grabbing a CSV export and restoring your app is you will have an outage for a few minutes. (but it’s pretty much the only option you’ve got - but it’s perfectly viable)
After 2 days (for Starter), 24 (for Growth) or 20 days (for Team) you have no restore options, as that’s the duration days of backups available.
Consider using my product PlanB - it will automatically take daily CSV download backups of your tables. https://planbbackups.io Also it can take daily exports of your Bubble app and save them away with your data. So you have your data and app backed up permanently and remotely in AWS (EU or US) that you can download anytime.
1 Like
