Sanjeev Sabhlok's notes on technology, hardware, gardening

Remove spam ghost entries using PhpMyAdmin (clears comment metadata)

Run this query on phpmyadmin regularly:

DELETE FROM wp_commentmeta WHERE meta_key

LIKE "%akismet%"

 

to get rid of excessive commentmetadata

 

ALSO THIS:

 

DELETE FROM wp_commentmeta WHERE comment_id

NOT IN (

SELECT comment_id

FROM wp_comments

)

Print Friendly

sabhlok

View more posts from this author

Leave a Reply

Your email address will not be published. Required fields are marked *