WordPress.org

Support

Support » Plugins and Hacks » [Resolved] Blicki – Can I Empty wp_post_revisions Table in Database?

[Resolved] Blicki – Can I Empty wp_post_revisions Table in Database?

  • imagiscapeca

    @imagiscapeca

    My revisions database/table is huge – 5 times the size of my posts table. If I empty it, will that affect the current posts?

    I couldn’t find an answer in forums or documentation or anywhere, so I did a test, which answers my own question, and hopefully yours too:

    Using phpMyAdmin (accessed via my host’s cPanel):

    1. I deleted one post’s revisions, and the post remained intact as expected.

    2. I emptied the wp_post_revisions table – no problems resulted.

    3. I didn’t need to empty wp_post_revision_ids – it wasn’t a large file, but I didn’t need a record of how many revisions I had made to posts, so I emptied it too – no problems resulted.

    In Conclusion:

    Yes.

Viewing 4 replies - 1 through 4 (of 4 total)
  • I wish!! In the current 2.6, there is no wp_post_revisions table; revisions and simply included in wp_posts and not so easy to get rid of.

    My table has grown massively with unwanted large posts that are unconditionally added. I am seriously contemplating reverting to 2.5.

    Simplest way now is to run SQL:

    Delete from wp_posts where post_type=’revision’;

    Simplest way to disable the post revisions feature is to add the following code to your wp-config.php file:
    define('WP_POST_REVISIONS', false);

    Thanks for allthe solutions! 🙂 Definitely going to be implementing this on my site(s)

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘[Resolved] Blicki – Can I Empty wp_post_revisions Table in Database?’ is closed to new replies.
Skip to toolbar