stylish - functional - affordable - successful

Remove Spam From WordPress Database

I was just doing a clean up of my wordpress databases and realised that the SPAM comments were still being recorded in the akismet history, so after an extensive search I found an easy solution to removing the entire history files without removing the approved comments and pingbacks.

I now use this procedure to remove Akismet history from my database:

  1. Go into control panel dashboard and find phpMyAdmin
  2. On the left hand side select the database associated with the website I want to work on (such as _wrdp1)
  3. Take a copy of the database before making any changes by selecting EXPORT and press go. Download the sql file to a safe place.
  4. Go to wp_commentmeta
  5. Select the SQL tab
  6. Copy and paste the query below (making sure to add the correct database name if it has been changed for security reasons) and press go. It generally takes less than a second to remove all the history and free up the database space again. Bravo!

DELETE FROM wp_commentmeta WHERE meta_key LIKE ‘%akismet%’


Elizabeth Richardson currently lives on The Gold Coast Of Australia and is a mother, teacher, business developer, author of the International Best Seller 500 Confessions, founder of The Appreciation Space and Get Rid Of Bad Habits - for good! As a teacher she helped many small business owners get started with Build Your Own Websites Classes in South Gippsland and on The Gold Coast. These days Elizabeth enjoys a life of total luxury but still plays as a writer, professional photographer and web designer. Her passion for living, loving and laughing, remains at the forefront of her focus.

Recommended Website Hosting

Get Occasional Email Updates

Enter your email address:

Delivered by FeedBurner

See What Our Sponsor Has To Offer