Blog Crashed – how to restore posts from database?

Hello everyone,

Yesterday something terrible happened to me. My WordPress blog crashed and I couldn’t log in to my admin site.
After several hours of trying to fix the problem and nothing worked, I decided to delete all folders (except the CONTENT one) and made a new installation of my wordpress site.

Now my blog is online on https://www.project-beautiful.de/wordpress

But as expected all my posts and stuff is gone.. and I had no backup from wordpress.

However I still have my database running like normal and I saw my posts there. Is there a possibility to restore my Blog? I also have all the data in the CONTENT folder, which wasn’t damaged or anything at all. I just couldn’t logg in to my site anymore and reacted in installing everything new.

I tried to find a solution on google, but people are facing different problems like me and I get confused. Im pretty new to wordpress.

Can anyone help me out of my misery?
I would be so grateful ??

Regards