I have 100,000 word press comments

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Sly
    Let's do some business!
    • Sep 2004
    • 31376

    #1

    I have 100,000 word press comments

    Which are all garbage of course. I want to trash them all. Is there a plug-in to do this? I've searched but haven't been able to find one.
    Vacares - Web Hosting, Domains, O365, Security & More - Paxum and BTC Accepted

    Windows VPS now available
    Great for TSS, Nifty Stats, remote work, virtual assistants, etc.
    Click here for more details.
  • Jdoughs
    Confirmed User
    • Mar 2004
    • 5794

    #2
    I just do a dump on that table in mysql, then install Akismet.
    LinkSpun - Premier Adult Link Trading Community - ICQ - 464/\281/\250
    Be Seen By New Webmasters/Affiliates * Target out webmasters/affiliates based on niches your sites are for less than $20 a month.
    AmeriNOC - Proudly hosted @ AmeriNOC!

    Comment

    • st0ned
      Confirmed User
      • Mar 2007
      • 8437

      #3
      Use Akismet, it comes with Wordpress. Plugin your wordpress.com API key then click scan comments and it will remove all of the garbage.
      Conversion Sharks - 1,000+ adult dating offers, traffic management, and consistently high payouts.
      We will guarantee and beat your current EPC to win your dating traffic!
      Skype: ConversionSharks || Email: info /@/ conversionsharks.com

      Comment

      • Sly
        Let's do some business!
        • Sep 2004
        • 31376

        #4
        I was afraid of doing a simple dump like that, I did not know if WordPress cross-references the information or catalogs the data anywhere else, etc.

        You haven't had any problems doing it?
        Vacares - Web Hosting, Domains, O365, Security & More - Paxum and BTC Accepted

        Windows VPS now available
        Great for TSS, Nifty Stats, remote work, virtual assistants, etc.
        Click here for more details.

        Comment

        • bloggerz
          Too lazy to set a custom title
          • Dec 2006
          • 16255

          #5
          Akismet would do the trick
          I SELL ADULT BACKLINKS! Email: eroticweb>gmail SKYPE: gfybloggerz

          $$$$$ MAKE HUGE MONEY IN CAMS - CLICK HERE $$$$$

          Comment

          • Jdoughs
            Confirmed User
            • Mar 2004
            • 5794

            #6
            I didn't realise Akismet had the scan option, if so its prob best bet.
            LinkSpun - Premier Adult Link Trading Community - ICQ - 464/\281/\250
            Be Seen By New Webmasters/Affiliates * Target out webmasters/affiliates based on niches your sites are for less than $20 a month.
            AmeriNOC - Proudly hosted @ AmeriNOC!

            Comment

            • Sly
              Let's do some business!
              • Sep 2004
              • 31376

              #7
              I have the scan running right now. :-)

              Thanks.
              Vacares - Web Hosting, Domains, O365, Security & More - Paxum and BTC Accepted

              Windows VPS now available
              Great for TSS, Nifty Stats, remote work, virtual assistants, etc.
              Click here for more details.

              Comment

              • Sly
                Let's do some business!
                • Sep 2004
                • 31376

                #8
                It keeps timing out. I may have too many. LOL.
                Vacares - Web Hosting, Domains, O365, Security & More - Paxum and BTC Accepted

                Windows VPS now available
                Great for TSS, Nifty Stats, remote work, virtual assistants, etc.
                Click here for more details.

                Comment

                • ExLust
                  Confirmed User
                  • Aug 2008
                  • 3223

                  #9
                  Bump for you.

                  BE A PARTNER

                  Comment

                  • Jayvis
                    Confirmed User
                    • Nov 2005
                    • 5430

                    #10
                    Glad to know I'm not the only one with incredible wordpress spam problems, I was just about to start a thread about the same thing. I mean, it never even get's published anyways, what's the point??

                    Comment

                    • fris
                      Too lazy to set a custom title
                      • Aug 2002
                      • 55679

                      #11
                      Originally posted by Sly
                      It keeps timing out. I may have too many. LOL.
                      http://www.wprecipes.com/mark-asked-...wordpress-blog
                      Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence.

                      Comment

                      • fuzebox
                        making it rain
                        • Oct 2003
                        • 22352

                        #12
                        I just delete them directly through the mysql admin command line... You can probably do the same through phpmyadmin.

                        delete from wp_comments;

                        Comment

                        • blonda80
                          FOR HIRE: AFF Manager
                          • May 2006
                          • 10959

                          #13
                          i disabled comments. pissed me off to see how many spammers are replying to my posts without saying something about the post.
                          i also use Spam Karma 2 and is very useful
                          Weekly Paying Affiliate Program with Dating Cam Offers!
                          TrafficGoldmine.com is the official home of HookUP.com
                          They offer payments by PayPal, Paxum, BTC, Bkash, Webmoney & more!

                          Comment

                          • Houdini
                            Confirmed User
                            • Dec 2001
                            • 1651

                            #14
                            If you're still having trouble, try it through phpadmin. I had the same problem, although not 100K, but this worked http://educhalk.org/blog/?p=133

                            Comment

                            Working...