Migrating from WordPress to Pure Comments

I've been a very happy Pure Blog user for some weeks now. There was one small thing left: migrating my old comments from WordPress to Pure Comments, another piece of minimalist quality software by Kev Quirk. This is a public note on how I did it. YMMV. The Strategy Follow the Pure Comments docs to install it. After that, the main challenge is matching the old WordPress database IDs to the new flat-file .md posts. Luckily, both systems use the slug (the URL-friendly title). WordPress stores this in the post_name column. By joining the comments table with the posts table during export, we can link every comment to the correct slug. 1. The Migration Script This is a one-time shell script to pipe comments directly from MySQL into the Pure Comments SQLite database. Note: It filters out "pingbacks" and "trackbacks" to keep your comment section clean, and it handles nested comments by preserving the original IDs. First get a list of posts with real comments. SELECT GROUP_CONCAT(DISTINCT…