Reset WordPress?

[sarataylor]

Hello!
I wonder if there is any way to clear all the posts in a WordPress blog, other than clicking Delete on every single one.

 

[Jack London]

Hello!
I wonder if there is any way to clear all the posts in a WordPress blog, other than clicking Delete on every single one.

method 1:
Login to your phpmyAdmin and running queries on database you want to remove wordpress posts

SELECT *
FROM wp_posts a
LEFT JOIN wp_term_relationships b ON ( a.ID = b.object_id )
LEFT JOIN wp_postmeta c ON ( a.ID = c.post_id )
LEFT JOIN wp_term_taxonomy d ON ( d.term_taxonomy_id = b.term_taxonomy_id )
LEFT JOIN wp_terms e ON ( e.term_id = d.term_id )
WHERE e.term_id =<category id>

now you selected records that you will delete, continue running code

delete a,b,c,d
FROM wp_posts a
LEFT JOIN wp_term_relationships b ON ( a.ID = b.object_id )
LEFT JOIN wp_postmeta c ON ( a.ID = c.post_id )
LEFT JOIN wp_term_taxonomy d ON ( d.term_taxonomy_id = b.term_taxonomy_id )
LEFT JOIN wp_terms e ON ( e.term_id = d.term_id )
WHERE e.term_id =<category id>

replace <category id> above by your category id having posts in it ( you will delete posts in this categories )

method 2:

delete FROM wp.wp_terms;
delete FROM wp.wp_term_taxonomy;
delete FROM wp.wp_term_relationships;
delete FROM wp.wp_posts;
delete FROM wp.wp_postmeta ;

method 3:
simple to remove posts but information still exist on other tables like terms, taxomony, relationship...
Here's code:

DELETE FROM `wp_posts`
WHERE  `post_type` =  'prefix-numberplates'
LIMIT 0 , 10000

Hope you will choose one of ways above and it's useful to you.!!