How can the "backups" created by Local be used?

I’m getting very desperate for a solution now to revert a site prior corruption.
I noticed that Local seems to create backups of the SQL automatically.
How can I proceed to implement this as a possible way to fix my sites that got corrupted?

In ~/Local Sites/app/sql there should be an .sql backup for your DB. Were you able to find this?

Yes, I was just wondering how these zips can be used and when do they get created?