I thought my “huge” site with 2000 posts was huge…
Regarding the “How do I get the database to my local installation” have a look at the MySQL workbench. They have a migration assistant that is relatively easy to understand (very techy language they use but understanding you can) and can continue failed or partial migrations. Just be careful and DO NOT select anything that wraps your SQL query into transactions. This will probably fail on the wp_posts table. (Transactions are SQL queries that are “collected” and run together in the end. I guess 70.000 posts will kill RAM and swap and all your XAMMP has to offer.
Regarding the timeout issues with the WP to Hugo exporter that you will run into: open the file in the plugins folder that has the plugins-folder-name (probably /wp-content/plugins/wp2hugo/wp2hugo.php or something like that) and add the following line in line 2 (
<?php has to come in line 1):
that will take care with the timeouts. When you run the exporter it might take some hours, my 2000 entries were about 10 minutes on a crappy computer.
The last limitation you might run into is the space this will take up.
If all that fails you could try to use the migration assistant in the Workbench to import 5000 posts, then export them to hugo, then delete them, then import the next 5000 then export then delete then import export delete and so on. Sounds like a lot of work
Edit: I forgot the link for the Workbench: https://www.mysql.com/products/workbench/