Setting all posts to published

  • How can I set all the posts in my wp_posts table to “publish” instead of “drafts”?

    The problem is that I imported them from MT (from Diaryland, actually, in MT exp format), and now they don’t show up in my Manage tab. They ARE there though, I see them all in wp_posts. They’re set as drafts, but I don’t see them on the top in the “drafts” section in the Manage tab, only in mySQL.

Viewing 1 replies (of 1 total)

  • Run this in PHPMyAdmin or some other place you can run a MySQL query (of course only after backing up your database, at your own risk, etc.):

    UPDATE wp_posts SET post_status = 'publish' WHERE post_status = 'draft'

Viewing 1 replies (of 1 total)
  • The topic ‘Setting all posts to published’ is closed to new replies.

Tags