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

1 Views

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:

Read More

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?

Post Views: 1

Related posts

Leave a Reply

2 comments

  2. 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;

    (uncomment lines after the --end config, by deleting the leading -- In order to run the query. But be careful, it is destructive. See the query below on how test your query to see what will be deleted, before you run it.)

    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

    SET @WPUSERID='1';
-- end config

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;