WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Some way to Flush or Overwrite all Imported Content in a Site for a Fresh Import - How?

  • Is there an easy quick way to do this? To delete all Pages, Posts, Comments and stuff that got imported?
  • Or some way to force a FLUSH of the information when I import a new .XML?
  • I've imported a bunch of wrong content into several sites
  • I would like to give them a FRESH start, preferably without having to Re-Create Fresh Sites on Multisite WP 3.5.1 Network
  • Make it go back to the state when a Fresh New Site was created

With relation to other links I've read:

I haven't gotten a conclusive answer here. Not even when I put together all the LEARNING from the links I've read (posted).

Is there a way to combine all the above knowledge to create solution steps for this?

Shouldn't there be a Plugin, Script or some Tool in the Wordpress Admin/ Developer's Tool chest to do this sometime when needed?

Is there something like this out there?

share|improve this question
up vote 2 down vote accepted

This may be what you're looking for http://wordpress.org/extend/plugins/suicide/. As a super admin you can select which sites you would like to remove the content from within your multisite setup.

share|improve this answer
nice name; Suicide! – numediaweb Sep 21 '13 at 20:51

Run A Query to Delete All posts before Import

Because menus and pages are custom post types, this will update all posts, pages, and menus to be replaced by your import file.

  1. Delete all posts in the target server by running a database query. Note that the code requires setting a userid. modify it if there are more users or run it more than once.

SET @WPUSERID='1'; -- end config -- Delete a,b,c 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) WHERE a.post_author = @WPUSERID;

  1. Import the XML file to the target.

Caution: Back up your databases for both servers in case you accidently get them mixed up (you think you're connected to stage for example, and you are really connected to dev when you do the delete) .

Be safe: view posts before deleting

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) WHERE a.post_author = @WPUSERID; 
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.