How to import posts from sql backup file into a fresh wordpress installation

I just need the posts, I don’t mind that I don’t have other functionality.

https://codex.www.ads-software.com/Restoring_Your_Database_From_Backup

what if I only want to import some of the tables? Same process?

Importing just some of the tables could be tricky as there are cross-table relationships to take into consideration.

I was able to do an insert of my posts table and it worked. I didn’t need the comments but if I did I would also do the same insert for the comments. This seemed to be the cleanest way and worked great.