Set all entries to Draft?

  • Shawn

    (@shawnogordo)


    17 years, 7 months ago

    I’m going to be doing some work on my WordPress site, and I’d like to revert all of my blog entries to “Draft,” as I’ll be bringing them all back on-line one by one. (It’s a long story.) Is there any way that I can universally set all entries to “Draft” without having to do it manually, entry by entry?

Viewing 1 replies (of 1 total)

  • First backup your database.

    Then use phpMyAdmin with this SQL code:

    UPDATE wp_posts SET post_status = 'draft' WHERE (post_type ='post' and post_status = 'publish') ;

    Verify that it worked.

Viewing 1 replies (of 1 total)
  • The topic ‘Set all entries to Draft?’ is closed to new replies.

Tags