restore blog posts from db backup

Hi. I had a blog, then I changed to a new domain name. I backed up my blog and my DB, but both failed when I attempted to restore. Not a big deal as my blog is a bunch of goofy stuff that no one reads ?? However, there is one blog post that I keep getting requests for “where’s that story you wrote about…”

My understanding is that blog posts in WP are stored in the DB, so it seems to me that if I have the DB backup, I can access the blog posts. But, I don’t know the process.

I’m looking for guidance on how to “restore” the database so I can retrieve some of my lost blog entries. Any thoughts? This is a MySQL DB.

Thanks in advance!
John