Hi I accidentally deleted 50000 lines from a table that I need. Is there a way to restore this?
2 Likes
Hey @upsport,
Yes, you may want to DM @AbbeyHernandez with your domain and the timestamp you want your database to be restored to.
Cheers!
1 Like
Hey @upsport,
@MiguelOrtiz is correct. Ask them how far back they can go to see if it good enough for your environment. If you want more control, Retool uses Neon under the hood.
At Neon you can do a point in time restore for up to 30 days. Coupled with branching this is a great solution.
Hi @upsport 
So sorry to hear you lost some data from your table. Could you please DM me the tableId and the time you'd like to revert it to with the time zone (UTC)?
@AbbeyHernandez just curious. a) How far back can you go in time to revert? b) Can you revert just a table or does it need to be the entire db?
We can only go back 7 days from the current moment. We can revert both a table and a database.
2 Likes
Great questions @Shawn_Optipath!
1 Like
Hi Abbey. They table is called manual_title_tag. If you can go revert just that table back to 02/25 and 1am UTC that would be awesome!
1 Like
Thanks @upsport, a snapshot resource should be live for your org now.
To recover lost data you can now query the snapshot resource like any other PostgreSQL resource. For example:
- create a short-lived app to transfer data from the snapshot resource to Retool DB
- pull data in Query Library, export to CSV, and import through the Database UI
Let me know if there's anything else I can assist with!
2 Likes
Awesome. I was able to get it. Thanks so much!!
1 Like
Of course! Let me know if there's anything else you need. Happy to help.
1 Like
2 posts were split to a new topic: RetoolDB recovery
A post was split to a new topic: Help recover Retooldb table