How to Delete All Posts in WordPress
If you need to kill all the posts you have written, you’re welcome to use a simple plugin. Its name sounds very nice: WordPress Suicide. What does this plugin do? It allows to truncate all major tables like wp_posts and wp_terms. It’s just if you need to remove ALL posts and all categories, not one by one.