big fool

Dear Lord, I made a huge mistake. My intentions were good. But it all blew up in my face! Now every one has turned on me. And I feel like a big fool. I beat myself up for it every day and so does every one involved. How can I recover?