Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact us.

Post New Thread Reply

Register GFY Rules Calendar
Go Back   GoFuckYourself.com - Adult Webmaster Forum > >
Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed.

 
Thread Tools
Old 02-05-2009, 07:59 AM   #1
Kard63
Confirmed User
 
Kard63's Avatar
 
Join Date: Nov 2003
Location: 237 619 975
Posts: 8,944
Best way to delete 12,000 wordpress comments?

What is the best way to delete these fuckers?


I know some ignorant trolls will give me ways to prevent it from happening in the first place instead of answering my question but thanks in advance to anyone who actually helps.
__________________
Kard63 is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 02-05-2009, 08:02 AM   #2
Machete_
WINNING!
 
Industry Role:
Join Date: Oct 2002
Posts: 14,579
get someone that know mysql to write you a dump to phpmyadmin.

Copy-Paste-Execute-Done

Last edited by Machete_; 02-05-2009 at 08:04 AM..
Machete_ is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 02-05-2009, 08:07 AM   #3
Sosa
In Tushy Land
 
Sosa's Avatar
 
Join Date: Oct 2002
Location: Nebraska
Posts: 40,149
I'd suggest phpmyadmin as well
Sosa is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 02-05-2009, 08:09 AM   #4
Libertine
sex dwarf
 
Libertine's Avatar
 
Join Date: May 2002
Posts: 17,860
Quote:
Originally Posted by ebus_dk View Post
get someone that know mysql to write you a dump to phpmyadmin.

Copy-Paste-Execute-Done
This. Shouldn't take more than 5 minutes, and that includes making a cup of coffee and drinking it.
__________________
/(bb|[^b]{2})/
Libertine is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 02-05-2009, 08:15 AM   #5
Antonio
Too lazy to set a custom title
 
Antonio's Avatar
 
Join Date: Oct 2001
Location: Spartaaaaaaaaa
Posts: 14,136
phpmyadmin - export your database as sql file to your HD, keep one back up copy
open the sql file in a text editor
find table wp_comments
delete all comments
import database back using phpmyadmin
Antonio is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 02-05-2009, 08:16 AM   #6
Antonio
Too lazy to set a custom title
 
Antonio's Avatar
 
Join Date: Oct 2001
Location: Spartaaaaaaaaa
Posts: 14,136
you can execute SQL quiery directly in phpmyadmin, but the chances of you fucking up are much hgher ;)
Antonio is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 02-05-2009, 08:17 AM   #7
tranza
ICQ: 197-556-237
 
Join Date: Jun 2003
Location: BRASIL !!!
Posts: 57,559
I'm bookmarking this thread for future reference.

__________________
I'm just a newbie.
tranza is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 02-05-2009, 08:18 AM   #8
V_RocKs
Damn Right I Kiss Ass!
 
Industry Role:
Join Date: Dec 2003
Location: Cowtown, USA
Posts: 32,405
Do they follow a pattern?
V_RocKs is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 02-05-2009, 08:18 AM   #9
kowalsky
Confirmed User
 
kowalsky's Avatar
 
Join Date: Oct 2003
Posts: 2,494
yeah, I had to deal with that shit a few weeks ago. Then I asked my server admin to do it on the DB.
__________________
Jimmy Kowalsky
www.catchycash.com
[email protected]
ICQ - 7319094

kowalsky is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 02-10-2009, 04:14 AM   #10
GrouchyAdmin
Now choke yourself!
 
GrouchyAdmin's Avatar
 
Industry Role:
Join Date: Apr 2006
Posts: 12,085
delete from wp_comments where 1=1;

all done.
__________________
GrouchyAdmin is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 02-10-2009, 04:51 AM   #11
georgeyw
58008 53773
 
georgeyw's Avatar
 
Industry Role:
Join Date: Jul 2005
Location: Australia
Posts: 9,864
Quote:
Originally Posted by Kard63 View Post
What is the best way to delete these fuckers?


I know some ignorant trolls will give me ways to prevent it from happening in the first place instead of answering my question but thanks in advance to anyone who actually helps.
I'm guessing you don't know anything about mysql - if you have phpmyadmin, login to the db, select the table and top right is an 'empty' link. Click that and your comments table will be free of spam (and ALL other comments).
__________________
TripleXPrint on Megan Fox
"I would STILL suck her pussy until her face caved in. And then blow her up and do it again!"
georgeyw is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 02-10-2009, 05:05 AM   #12
darksoul
Confirmed User
 
darksoul's Avatar
 
Join Date: Apr 2002
Location: /root/
Posts: 4,997
Quote:
Originally Posted by GrouchyAdmin View Post
delete from wp_comments where 1=1;
Code:
delete from wp_comments where comment_approved=0;
__________________
1337 5y54|)m1n: 157717888
BM-2cUBw4B2fgiYAfjkE7JvWaJMiUXD96n9tN
Cambooth
darksoul is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 02-10-2009, 05:22 AM   #13
CaptainWolfy
Playa
 
CaptainWolfy's Avatar
 
Industry Role:
Join Date: Dec 2005
Location: Somewhere on the Earth
Posts: 8,439
spam karma... plugin for wp
CaptainWolfy is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 02-10-2009, 05:25 AM   #14
TheDoc
Too lazy to set a custom title
 
TheDoc's Avatar
 
Industry Role:
Join Date: Jul 2001
Location: Currently Incognito
Posts: 13,827
Upgrade your Wordpress to current, click the spam count # on the dashboard. Click the "Delete All Spam" button.

It's built straight into the new wp..
__________________
~TheDoc - ICQ7765825
It's all disambiguation
TheDoc is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Post New Thread Reply
Go Back   GoFuckYourself.com - Adult Webmaster Forum > >

Bookmarks



Advertising inquiries - marketing at gfy dot com

Contact Admin - Advertise - GFY Rules - Top

©2000-, AI Media Network Inc



Powered by vBulletin
Copyright © 2000- Jelsoft Enterprises Limited.