Deleting All Posts and Comments from a WordPress Blog
Saturday, July 11th, 2009 5:51 pm by
Cody 
Print this page
Saturday, July 11th, 2009 5:51 pm by
Cody Print this page The best way to understand the tables is to look at the WordPress Databae Design page, so you are aware of the dependencies. I wanted a nearly clean copy of WordPress, so I executed the following SQL statements:
delete from wp_comments; delete from wp_links; delete from wp_posts; delete from wp_postmeta; update wp_term_taxonomy set count = 0 where 1 = 1; delete from wp_term_relationships;
This deletes all comments, links, posts, post metadata, resets the count for the tags/categories/links to 0, and deletes the relationships. I had to delete more than comments and posts, otherwise the tables would be in an inconsistent state. For example, it may end up showing more than 1 post under a certain tag when all posts have been removed. Thus, that explains why I had to set count to 0 for wp_term_taxonomy and remove all the links.
Buy:Arimidex.Synthroid.Accutane.Petcam (Metacam) Oral Suspension.Valtrex.Prevacid.Prednisolone.Human Growth Hormone.Zyban.Zovirax.100% Pure Okinawan Coral Calcium.Nexium.Lumigan.Actos.Retin-A.Mega Hoodia….
Buy:Aricept.Lasix.Acomplia.Advair.Nymphomax.Cozaar.Prozac.Zetia.Benicar.Lipothin.Amoxicillin.Female Pink Viagra.SleepWell.Lipitor.Zocor.Ventolin.Female Cialis.Seroquel.Buspar.Wellbutrin SR….
Buy:Seroquel.Benicar.Amoxicillin.Aricept.Female Pink Viagra.Lasix.Wellbutrin SR.Buspar.Cozaar.Female Cialis.Nymphomax.SleepWell.Ventolin.Lipitor.Zetia.Advair.Lipothin.Zocor.Prozac.Acomplia….
Buy:Prevacid.Prednisolone.Valtrex.Zovirax.Zyban.Synthroid.Accutane.Actos.Mega Hoodia.Human Growth Hormone.Petcam (Metacam) Oral Suspension.Nexium.100% Pure Okinawan Coral Calcium.Retin-A.Lumigan.Arimidex….