WordPress Developer Tips: Deleting Spam Comments in the Database
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.
Hi, I'm Morten Rand-Hendriksen, staff author at lynda.com, and I'm excited to welcome you to WordPress Developer Tips, Deleting Spam from the Database. In this advanced developer course, we'll look at how you can use simple sequel queries, to delete spam, and other types of commons directly from the database, without having to go through the WordPress admin interface. We'll start out by looking at how you can protect your site from ever getting a spam problem, then, I'll walk you through the process of identifying the different types of content, within the database you need to change.
We'll run queries on the different tables to first delete the comments, and then delete the comments meta. And finally I'll show you some different queries you can use to target different types of comments. Either published, pending, trashed or spam. So, lets get cracking with Word Press developer tips deleting spam from the Database.
There are currently no FAQs about WordPress Developer Tips: Deleting Spam Comments in the Database.
PHP with MySQL Essential Training3,907,848 Views
Deke's Techniques1,435,609 Views
HTML Essential Training3,250,120 Views
WordPress 3: Building Child Themes948,852 Views
The Practicing Photographer1,607,809 Views
PHP with MySQL Beyond the Basics2,199,079 Views
DSLR Video Tips2,375,992 Views