Publishing all pages at once? (2 posts)

  1. exit53
    Posted 8 years ago #

    Is there a way to publish all pages at once? I've created about 80 pages yet none are published - do I have to do each one manually?

  2. Kafkaesqui

    Posted 8 years ago #

    If you have access to your database through a tool (like say phpMyAdmin) that allows SQL queries, this will do it:

    UPDATE wp_posts SET post_status = REPLACE(post_status, 'draft', 'publish') WHERE post_type = 'page';

    If using a different table prefix than the default (wp_), modify the name of the posts table -- wp_posts -- to suit.

Topic Closed

This topic has been closed to new replies.

About this Topic