Reset WordPress?

Jack London

Well-known member
Joined
Jul 9, 2012
Messages
158
Points
18
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

Code:
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

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:
Code:
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:

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.!!
 
Older Threads
Replies
5
Views
2,913
Replies
1
Views
2,693
Replies
2
Views
3,612
Replies
1
Views
2,539
Newer Threads
Replies
3
Views
4,319
Replies
1
Views
2,156
Replies
1
Views
2,835
Latest Threads
Replies
0
Views
51
Replies
0
Views
198
Replies
0
Views
87
Replies
0
Views
84
Similar Threads
Replies
5
Views
10,285
Replies
4
Views
7,264
Replies
6
Views
4,420

Latest Hosting OffersNew Reviews

Sponsors

Tag Cloud

You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.

Top