I just deleted all records in my table by mistake

💬 Queries and Resources
1
  1. My goal: to get my table back
  2. Issue: i just deleted all records with sql commend by mistake
  3. Steps I've taken to troubleshoot: -

Its just happened 17.07.2025 around 2:00-2:30 PM. Is there any way to get it back?

sciencemovement.retool.com
w3d_degerlendirme_atama - table name

2

@BAbarquez Help pls.

3

Hello @barnoloji, we got you! We were able to help you recover your database:

Created retool_db (production) recovery snapshot 2025-07-17T10:30:00Z! This resource is immediately accessible.

  • Resource identifier: 511cbfce-0044-43d1-97ae-679c9d039976
  • Expires 2025-07-24T10:30:00Z

You’ll need to manually export and reimport the data into your RetoolDB. Let me know if you have any questions about the restoration process!

4

My table named w3d_degerlendirme_atama is still in the database, but I deleted all the data in it with a wrong sql code on the date I specified.

5

@barnoloji The new database contains all the data from before the deletion.

6

image
image2844×1826 221 KB

I apologize if I misunderstood, but I still see it as empty, should I check a different source? I would appreciate it if you could direct me.

7

Of course! @barnoloji I'm here to help. Go to Resources and search for the snapshot mentioned in the reply above. Right now, you're searching in your original table.
Query the snapshot resource like any other PostgreSQL resource. Here are two ways you can recover your data:

  1. Create a short-lived app to transfer data from the snapshot resource to RetoolDB.
  2. Pull the data into the Query Library, export it to CSV, and import it through the Database UI.
1 Like
8

Thank you so much.

1 Like