GoFuckYourself.com - Adult Webmaster Forum - Best way to delete 150,000 wordpress comments?

GoFuckYourself.com - Adult Webmaster Forum (https://gfy.com/index.php)

- Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)

- - Best way to delete 150,000 wordpress comments? (https://gfy.com/showthread.php?t=1066574)

Arnox

04-30-2012 12:55 PM

Best way to delete 150,000 wordpress comments?

Blog spam, totally didn't notice it on one of my main sites. How do I get rid of this shit?

Houdini

04-30-2012 01:03 PM

Back your database up first in case something goes wrong. Go into phpadmin, then click the SQL icon and enter this command:

DELETE from wp_comments WHERE comment_approved = '0';

Arnox

04-30-2012 01:30 PM

Quote:

Originally Posted by Houdini (Post 18917216)

Back your database up first in case something goes wrong. Go into phpadmin, then click the SQL icon and enter this command:

DELETE from wp_comments WHERE comment_approved = '0';

I've never used phpmyadmin, and the website's on a pretty cheap host plan - not sure I can even install it. =/

19teenporn

04-30-2012 01:34 PM

Quote:

Originally Posted by Arnox (Post 18917249)

I've never used phpmyadmin, and the website's on a pretty cheap host plan - not sure I can even install it. =/

You don't need to install it.
Just go to your cpanel and click the PHPmyadmin icon

Markul

04-30-2012 01:36 PM

Can't you installed the akismet plugin and have it process all comments? I seem to recall doing this on a site with 10K+ comments held for moderation. Could be remembering wrong though.

tonyparra

04-30-2012 02:12 PM

http://www.nkuttler.de/wordpress/del...nding-comments

Supz	04-30-2012 02:25 PM

Quote:

Originally Posted by tonyparra (Post 18917325)

http://www.nkuttler.de/wordpress/del...nding-comments

what he said.

use the plugin 'delete pending comments'. it works great.

alias

04-30-2012 02:27 PM

Quote:

Originally Posted by Markul (Post 18917266)

Can't you installed the akismet plugin and have it process all comments? I seem to recall doing this on a site with 10K+ comments held for moderation. Could be remembering wrong though.

I thought I remembered the same thing.

FemdomEmpire

04-30-2012 05:01 PM

Shit, just had that problem. I ended up deleting all the posts with 1000's of comments, it got so out of hand it was crashing my SQL database.

garce

04-30-2012 05:03 PM

Don't use Wordpress anymore.

fris	04-30-2012 05:30 PM

never heard of this wordpress

All times are GMT -7. The time now is 06:57 AM.