33m 25s – Advanced
WordPress sites are prime targets for spam comments. Left unchecked, thousands or even hundreds of thousands of spam comments will bog down your database. Luckily, there are plugins like Akismet to help. And even when the volume is too large to be cleaned up with Akismet, you can use some smart, simple SQL commands to remove all the spam from your database in minutes. Morten Rand-Hendriksen shows you how to perform both spam-sweeping steps in this course.
Introduction – 3m 10s
Welcome – 1m 5s
What to know before you start this course – 2m 5s
1. Using Akismet to Curb Spam – 11m 21s
What is comment spam? – 3m 10s
Installing Akismet – 3m 57s
Deleting spam comments from WordPress Admin – 4m 14s
2. Deleting Spam from the Database – 17m 35s
Before you do anything: Make a backup of everything! – 2m 3s
Identifying spam in the comments and commentmeta tables – 3m 23s
Deleting spam comments with an SQL command – 2m 32s
Deleting spam commentmeta with an SQL command – 4m 13s
Optimizing your tables – 1m 59s
Deleting pending and other comments – 3m 25s
Conclusion – 1m 19s
Thank you! – 1m 19s