Spammers on WordPress

Salams

So today I logged on to one of the Clients WordPress and they told me that their site had been infested with Spam Comments over 3000 to be exact!

So i login to wordpress backend and try deleting them batch by batch! Gave up after few mins because it takes soo much time

 

this is where MYSQL Query comes handy!

Login to PHPmyadmin

Choose the WordPress Database

and run these queries

DELETE FROM `wp_comments` WHERE `comment_approved`=’spam’

DELETE FROM `wp_comments` WHERE `comment_approved`=’0′

Took 3 seconds! And all vanished!

So heres a tip incase you get filled with Spam!

Backups…backups…..

Someone asks us…….

“What are your backup methods”
We have 3 backup retention methods
Daily (Runs everynight)

Weekly (Runs once a week)

Monthly (Runs once a month)

These backups are done within the same Datacenter
+ Once a month we do an offsite backup to a totally different Datacenter

We backup everything the full account…files/databases/emails etc

However we would still recommend people do their own backups as well just incase anything goes wrong,

Remember always to make Backups

and backups are not for WIMPS!