Restoring Database to a Specific Past Date and Back to Current Date

gabriel.guerin · 2024-09-05T13:24:34.589Z

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!

cmarchan · 2024-09-05T15:14:16.845Z

Selective restoration is unfortunately not possible in either dev or live dBs.

code-escapee · 2024-09-05T16:06:41.833Z

Depending on your plan I believe you can restore back to july 11, export relevant data and then restore to sept 5.

gabriel.guerin · 2024-09-05T16:33:44.323Z

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!

code-escapee · 2024-09-05T16:46:52.986Z

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

cmarchan · 2024-09-05T17:57:50.740Z

This is possible @gabriel.guerin

CleanShot 2024-09-05 at 13.49.32@2x1948×1510 298 KB

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.

manual.bubble.io

Restoring database backups | Bubble Docs

This section covers how you can copy the contents of your database, as well as restore it to a snapshot of what it looked like at a specific date and time

gabriel.guerin · 2024-09-06T10:36:02.576Z

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.

image2111×2146 321 KB

code-escapee · 2024-09-06T22:42:42.729Z

I understood that to be your question from the get go so my responses above are to with regard to that question.

lindsay_knowcode · 2024-09-07T10:23:49.461Z

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.

Edit - PlanB can now also back the files in your File Manager.

drfalken · 2024-09-26T10:54:21.710Z

Hey @lindsay_knowcode can planB store to a google MySQL or maybe big table?

I use GCP for everything and would love to use looker for analytics of my bubble app!

georgecollier · 2024-09-26T11:14:17.929Z

gabriel.guerin:

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 did this without issue, except it was for one data type rather than all.

lindsay_knowcode · 2024-09-26T11:19:51.299Z

Probably works out of the box if you used a GCP Postgres DB. The use case of pulling your data into a DB for analytics is very valid - I do it all the time now with Supabase.

If we wanted to try, you just need a connect string to your destination Postgres DB. Why Postgres and not Mysql … so there is a no brainer auto mapping of the Bubble datatypes to the DB - Mysql doesn’t have a list type, and at some point, the privacy rules will be auto-portable

I’d be very happy to help support you to get GCP Postgres working …

drfalken · 2024-09-26T20:08:28.797Z

Rad thank you. Let me coordinate with my devs, I will DM you!

gabriel.guerin · 2024-10-30T09:13:41.205Z

Hey everyone, thanks for your replies. As you guys stated here in this thread, it is only possible to restore our database up to 20 days in the past unless we’re on the Enterprise plan. @lindsay_knowcode, I’m going to check out your solution called PlanB to avoid future problems like this. Looks like a great backup solution. Thanks a lot!

So, unfortunately, we’ve lost the accidentally deleted data. @georgecollier, thanks for letting me know that data recovery is possible, even for a specific type of data. I’ll mark it as the solution. However, I just have a couple of questions about what you did: so did you just restore a data type to a past date, export its data as a CSV, and then restore it back to today? Or did you just restore it back in time without restoring it back to today?