this post was submitted on 19 Jul 2023
80 points (96.5% liked)

main

1334 readers
34 users here now

Default community for midwest.social. Post questions about the instance or questions you want to ask other users here.

founded 3 years ago
MODERATORS
[email protected]
80
Dear lemmy, today I fucked up (midwest.social)
submitted 1 year ago by [email protected] to c/[email protected]
29 comments fedilink hide all child comments
 

Deleted something I shouldn't have. I learned my lesson, but I had to revert to a backup that was about 3 days old. My bad.

you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 2 points 1 year ago

W3 Schools entry on SQL DELETE statement

I don't know the actual table definitions for lemmy, but it should look something like:

DELETE FROM activitypub
WHERE createdDate < ((SELECT CURRENT_DATE) - interval '2 weeks')