Wordpress Themes - WP Forum at BFA
Click here to register or to donate.
Auto self-registration is not available here - far too many spammers. This forum has many, many backlinks and because of that there is an intense desire among spammers to drop their links here.

Wordpress Themes - WP Forum at BFA » Running WordPress » Installing & running WordPress »

Deleting multiple entries


  #1  
Old Feb 22, 2009, 12:07 PM
HenryGomez
 
30 posts · Feb 2009
Another generic wordpress question.

I realized that some of the 11,000 entries I imported from Movable Type were mapped incorrectly to the wrong authors. Probably my mistake. Anyway I've been isolating the months where this occurred and was wondering if there is a way to delete a lot of entries at once.

If I filter the entries by month it only shows me 15 at a time which means that in a busy month I have to delete 15 entries per page time 20 pages. I'd love to delete all the entries in the given month in one fell swoop so I can reimport them (mapped properly).
  #2  
Old Feb 22, 2009, 07:56 PM
Flynn's Avatar
Flynn
 
3,768 posts · Oct 2008
Munich, Germany
This should work, if executed in PHPMyAdmin via SQL tab, but only do this if you're brave and if you have a backup of your posts. I tested this query but not in Phpmyadmin, in fact I never used Phpmyadmin, and I cannot guarantee anything

To delete all posts of Jan 2009 (This also assumes that you have not changed your Wordpress table prefix from wp_ to something else, you probably haven't):

Code:
DELETE FROM wp_posts WHERE post_date REGEXP '^2009-01-' AND post_status = 'publish'
  #3  
Old Feb 22, 2009, 11:24 PM
HenryGomez
 
30 posts · Feb 2009
I just ended up sucking it up and deleting them manually. A plug-in for this would be great.
  #4  
Old Apr 15, 2009, 02:59 AM
superstrong
 
1 posts · Apr 2009
For future reference, if you want to know how to display more categories per page in Wordpress--especially for bulk deleting--just go into the wp-admin > categories.php file and find this section

Code:
if( ! isset( $catsperpage ) || $catsperpage < 0 )
	$catsperpage = 20;
and change "20" (i.e., display 20 categories per page) to whatever you want.

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Categories, Multiple versions of Altahualpa Jaguwar Atahualpa 3 Wordpress theme 16 Apr 27, 2010 09:55 AM
Sidebars: deleting headings and inserting my own susanesther Sidebars & Widgets 6 Jun 11, 2009 05:42 AM
Lost reader comment when deleting a post by mistake. Can it be restored ? CDT Post-Kicker, -Byline & -Footer 2 May 20, 2009 08:23 AM
Deleting Homepage & Text Size Changing ofpeb Atahualpa 3 Wordpress theme 0 Apr 21, 2009 04:20 PM
Deleting Menu bar daisy24 Page & Category Menu Bars 4 Feb 11, 2009 08:21 AM


All times are GMT -6. The time now is 11:32 AM.


Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.