[08:51:27] <Amir1>	 jynus: hi, how can I haz a query in a backup of m5 (the most recent one, unless it's made yesterday), do you need to recover the whole db? It's in mailman database (context T302816)
[08:51:42] <stashbot>	 T302816: Accidentally unsubscribed everyone from open-glam mailing list - https://phabricator.wikimedia.org/T302816
[08:52:24] <jynus>	 sorry, could you redo your question? Or let me read the ticket, maybe that has your question explained
[08:52:51] <Amir1>	 jynus: basically I need something from the most recent backup of m5
[08:53:02] <Amir1>	 to recover a human error
[08:53:10] <jynus>	 gotcha
[08:53:43] <Amir1>	 I already have the query, I don't know if you have to fully recover a db to be able to query or something similar, I hope it's not too much work
[08:53:56] <jynus>	 do we have a timestamp when the incident happened? We have a backup for example for that night
[08:55:00] <Amir1>	 let me check
[08:55:42] <Amir1>	 jynus: it should be a bit before: Tue, Mar 1, 4:46 (UTC+1)
[08:55:46] <Amir1>	 4:46 pm
[08:55:57] <jynus>	 ok, let me check what options we have
[08:57:15] <jynus>	 yeah, we have one from 2022-03-01 05:52:59 (that is am)
[08:57:25] <Amir1>	 awesome
[08:58:05] <jynus>	 let me see if we need to recover or I can get you the list of emails directly
[09:03:20] <jynus>	 let me switch to pms as just in case there is some sensitive info here
[09:03:54] <Amir1>	 yeah, it's not public
[09:32:05] <jynus>	 so having disscussed in private the concrete recovery numbers, let me offer any additional help you may need from me
[09:32:24] <Amir1>	 yeah, I think it's fine now. Thanks
[09:32:42] <jynus>	 ok, let me know on ticket when done, so I can cleanup the temp recovery files :-)
[09:32:51] <jynus>	 so that Amir is happy afterwards :-)
[09:51:11] <jynus>	 In related news, snapshots tonight went very well
[11:14:25] <jynus>	 thanks, I've cleanup the temp db and temp recovery files