Clean up your WordPress database with this one weird trick

Honey, I shrunk the database

First off, if you’re not regularly backing up your WordPress® database, go do it right now. Seriously. The words here will wait.

Backed up? Good. Ahem.

Now then, if you’re managing your own WordPress site, you definitely want and need to keep it cleaned up and in optimal form. Part of doing this is getting rid of the cruft that accumulates in your WordPress database. Spam comments and other digital detritus can cause your database to balloon in almost no time.

Just as you sometimes need to recharge to get your brain back in tip-top shape, so you need to clean out the junk that accumulates in your database over time, just from use.” ~ Luvvie Ajayi

Luvvie over at Awesomely Techie has written a great tutorial called “How to Optimize your WordPress Database,” and it’s definitely worth checking out.

Optimize WordPress Database

Using a couple of tools like the WP-Cleanup plugin and some judicious tweaking of the database (again, careful!) with phpMyAdmin, Luvvie was able to get rid of tens of thousands of rows of data that were gumming up her database, and was able to shrink her database by about 70 percent. Your milage may vary, of course, but if you want to try it yourself, check out Luvvie’s post.

For more great tips, check out the GoDaddy Tool Kit on BlogHer.

Image by: DanBrady via Compfight cc

Christopher Carfi
A veteran of both startups and the enterprise, Chris has a deep track record in developing customer community and evangelist programs for brands such as Adobe, H&R Block and Aruba Networks while holding executive positions at Ant’s Eye View and Edelman Digital, and he was co-founder and CEO at Cerado. He currently lives in the Bay Area with his family.