How to delete all comments from MultiSite? (4 posts)

  1. Razva
    Posted 1 year ago #


    When setting up WP MultiSite 4 years ago I've unfortunately forgot to disable/moderate comments, or activate Akismet. So I've just found out that some MultiSite websites have thousands of comments.

    In my network commenting is not required, so I would like to delete all approved/unapproved/pending comments. It's like...I want to delete ALL comments, regardless their state.

    How can I do this please?


  2. If something is truly urgent, you need to consider hiring someone via jobs.wordpress.net - otherwise you get to wait until a friendly volunteer pops in.

    Delete all comments from all sites? You'll have to do this in the DB.

    DELETE from wp_comments WHERE comment_approved = '0';

    And you'll want to run this changing wp_comments for each site, so wp_2_comments and so on.

    Want to turn comments OFF for all your sites? http://wpmututorials.com/how-to/close-comments-across-the-network/

  3. Razva
    Posted 1 year ago #

    Will this delete the approved comments also?

  4. No. That's what WHERE comment_approved = '0' means :) When your comments are approved, that number changes to 1

Topic Closed

This topic has been closed to new replies.

About this Topic


No tags yet.