Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
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.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.