WordPress.org

1. zooph
   Member
   Posted 1 year ago #

   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?

2. bindanaku
   Member
   Posted 1 year ago #

   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'

3. zooph
   Member
   Posted 1 year ago #

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

4. bindanaku
   Member
   Posted 1 year ago #

   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.

5. zooph
   Member
   Posted 1 year ago #

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

   DELETE FROM wp_comments WHERE comment_approved='0' ?

6. zooph
   Member
   Posted 1 year ago #

   ok found it!!!! great thanks!

Topic Closed

This topic has been closed to new replies.