![]() |
![]() |
![]() |
||||
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. |
![]() ![]() |
|
Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
Thread Tools |
![]() |
#1 |
Confirmed User
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.
__________________
|
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#2 |
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 |
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#3 |
In Tushy Land
Join Date: Oct 2002
Location: Nebraska
Posts: 40,149
|
I'd suggest phpmyadmin as well
|
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#4 |
sex dwarf
Join Date: May 2002
Posts: 17,860
|
This. Shouldn't take more than 5 minutes, and that includes making a cup of coffee and drinking it.
__________________
/(bb|[^b]{2})/ |
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#5 |
Too lazy to set a custom title
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 |
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#6 |
Too lazy to set a custom title
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 ;)
|
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#7 |
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. |
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#8 |
Damn Right I Kiss Ass!
Industry Role:
Join Date: Dec 2003
Location: Cowtown, USA
Posts: 32,405
|
Do they follow a pattern?
|
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#9 |
Confirmed User
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.
|
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#10 |
Now choke yourself!
Industry Role:
Join Date: Apr 2006
Posts: 12,085
|
delete from wp_comments where 1=1;
all done.
__________________
|
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#11 |
58008 53773
Industry Role:
Join Date: Jul 2005
Location: Australia
Posts: 9,864
|
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!" |
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#12 |
Confirmed User
Join Date: Apr 2002
Location: /root/
Posts: 4,997
|
Code:
delete from wp_comments where comment_approved=0; |
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#13 |
Playa
Industry Role:
Join Date: Dec 2005
Location: Somewhere on the Earth
Posts: 8,439
|
spam karma... plugin for wp
|
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#14 |
Too lazy to set a custom title
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..
__________________
![]() ![]() ![]() It's all disambiguation ![]() |
![]() |
![]() ![]() ![]() ![]() ![]() |