Nuking A Blog
Posted on June 9, 2009
Filed Under Blogging | 2 Comments
In an attempt to make this blog more professional, I deleted all of my old content. I want this blog to be about programming, technology, and the works. No personal stuff on here at all. I can do that in Facebook Notes or on my Myspace Blog if I want.
So with a little SQL and dissecting of this diagram, I figured out how to keep the content I wanted and delete the rest (without going through the web admin). All you really need to do is delete all posts except for those that are pages, then delete all comments (i kept 1), then delete all taxonomy terms by deleting everything (except for maybe the blogroll term) from wp_terms, wp_term_taxonomy, and wp_term_relationships.
It takes a little work, but it’s worth it.
Tags: Wordpress
