P paul Establishing Talker PF Member Messages 25 Highlights 0 Reaction score 0 Points 0 Peak Coin 0.000000¢ DB Transfer 0.000000¢ Thread Owner Jan 22, 2012 #2 I have left my comment settings to flexible and spammers have taken advantage. How can I removed tens of thousands of wordpress spam comments at once?
I have left my comment settings to flexible and spammers have taken advantage. How can I removed tens of thousands of wordpress spam comments at once?
G Guest Guest Jan 22, 2012 #3 You will first need to backup your database in myphpadmin You can then follow the steps below once you have downloaded your backup. 1. Go back to MyPhpAdmin 2. Click on you WordPress Database 3. Go to wp_comments and then click SQL at the top Once here you can enter the commands below and click " go " To remove all approved comments Code: DELETE FROM wp_comments WHERE comment_approved = 1 To remove all pending comments Code: DELETE FROM wp_comments WHERE comment_approved = 0
You will first need to backup your database in myphpadmin You can then follow the steps below once you have downloaded your backup. 1. Go back to MyPhpAdmin 2. Click on you WordPress Database 3. Go to wp_comments and then click SQL at the top Once here you can enter the commands below and click " go " To remove all approved comments Code: DELETE FROM wp_comments WHERE comment_approved = 1 To remove all pending comments Code: DELETE FROM wp_comments WHERE comment_approved = 0
