deleting over 10,000 spam comments without using moderation page

  • uhmmm…

    Ive been away for a few months and now have over 10,000 comments (spam) in my comments moderation q. The problem is the data crashes my browser b 4 i can download all the comments for a mass delete, how can i delete the lot without referring to this page?

Viewing 5 replies - 1 through 5 (of 5 total)

  • You can do this from your MySQL database. If you would like to assume that all of the 10.000 unmoderated comments are spam, delete them with this query:
    DELETE FROM wp_comments WHERE comment_approved='0'

    Thread Starter zooph

    (@zooph)

    thanks so much for the info… but how exactly is this done, how do i access MySQL database?

    Usually you get that info from your host. Or if you have access to your host control panel, look for the link with “MySQL Administration” or “phpMyAdmin”. You can see your login information for your database in the “wp-config.php” file.
    Once you’re there, you should be able to find a box to input the query.

    Thread Starter zooph

    (@zooph)

    thanks again, well i have access to “phpMyAdmin” on cpanel but where do i enter

    DELETE FROM wp_comments WHERE comment_approved=’0′ ?

    Thread Starter zooph

    (@zooph)

    ok found it!!!! great thanks!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘deleting over 10,000 spam comments without using moderation page’ is closed to new replies.

Tags