Parsing new .sql WordPress database from just raw site data(html pages,posts and media from wp-content, wp-uploads directories)

[mackdreye]

I unfortunately lost access to my original hosting account and didn't backup a copy of the original WordPress .sql database file.

I have since been able to successfully download a copy of all the raw website data from the Wayback Machine via the Wayback Machine downloader app on Ruby. So I now have a copy of all the original contents of the /wp directory which consists of all the html files and media.

In order to fully recover the site into a new live instance of WordPress, it requires a .sql database file that contains an index all the posts, webpages, categories and multimedia, which I am missing.

Are there any more straightforward methods available other than the complicated Python scripting methods I've found(WP-CLI or REST API or nokogiri app on BeautifulSoup) that would let me reparse all the raw site data that I have into a new functional .sql WordPress database file that would then allow me to republish my website in its original form?

I feel like I should create a WordPress plug-in for this. I'm surprised there isn't one already.

[swissspidy]

Maybe something like https://www.cmsfreedom.org/ is helpful in your situation.

Otherwise I suggest asking in a place like StackOverflow or perhaps Reddit, as it's not really a WP-CLI issue.

Good luck!