I was importing posts into wordpress and messed up. It’s not uncommon. I normally have a couple failed attempts, before I get everything zeroed in with a new csv template.
I’ve learned my lesson in the past so I always set the post author to a distinct user to easily bulk delete posts based on the post_author with sql.
However, this leaves trash in the wp_postmeta table so now we just clean that up by deleting everything without a entry in wp_posts.
1 2 3 4 5
Now that there is no trace of my failed attempt I can reprocess the file, hopefully successfully this time.