Results 1 to 1 of 1

Thread: Delete ALL Comments from Drupal

  1. #1
    Will.Spencer's Avatar
    Will.Spencer is offline Retired
    Join Date
    Dec 2008
    Blog Entries
    Thanked 2,329 Times in 1,259 Posts

    Delete ALL Comments from Drupal

    One of our Drupal sites was misconfigured and as a result it received thousands of spammy comments linking to very undesirable neighborhoods.

    Using the Drupal GUI to delete these was taking forever.

    Going straight to MySQL was a lot quicker.
    SQL Command to Delete all Unpublished Comments In Drupal:
    delete from comments where status = '1';
    SQL Command to Delete all Published Comments In Drupal:
    delete from comments where status = '0';
    As per usual, back up your database before monkeying with SQL directly.
    Submit Your Webmaster Related Sites to the NB Directory
    I swear, by my life and my love of it, that I will never live for the sake of another man, nor ask another man to live for mine.

  2. Thanked by:

    sturat (16 April, 2009), vanderkitty jones (3 May, 2009)

Similar Threads

  1. why always delete my site on
    By catding in forum Proxy List Support Forum
    Replies: 13
    Last Post: 3 March, 2011, 01:32 AM
  2. how to delete wp post in mysql ?
    By SonnyCooL in forum Databases
    Replies: 2
    Last Post: 29 June, 2010, 19:34 PM
  3. plugin delete old thread ?
    By SonnyCooL in forum Blogging
    Replies: 5
    Last Post: 24 April, 2010, 15:13 PM
  4. Delete ALL Comments from Wordpress
    By Will.Spencer in forum Wordpress
    Replies: 4
    Last Post: 17 April, 2009, 21:28 PM
  5. Replies: 8
    Last Post: 11 April, 2009, 19:43 PM

Tags for this Thread


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts