Optimize your Wordpress Database with WP-Optimize

WP-Optimize is a fantastic plug-in for WordPress that allows you to cleanup and optimize your WordPress SQL Database without logging into your MySQL Admin. This plug-in will clean up all your post revisions that are sit just wasting space in your database as well as cleaning out spam or unapproved comments.

You can even use WP-Optimize to Optimize the database and compress space to make your blog run faster and more efficiently, but probably one of the best things about WP-Optimize is the ability to completely rename an account to another account. WordPress does not let you rename your Admin account, you have to create a new account and make it an admin and delete your previous accounts.

With WP-Optimize you can just rename your admin account and leave all posts, comments and objects linked to the account intact. Say a user requests an account change, or you want to reassign posts from one account to another. You can simply rename the WordPress account and voila, without having to create a new account and delete a previous account.

WP-Optimize helped clean up nearly three thousand post revisions across all of my blogs.

Easy to install and easy to use, I recommend you give WP-Optimize a try if you are using WordPress 2.7 and above.

-Dragon Blogger

WordPress Plugins: Admin Management Xtended 2.0 So when I saw tonight that one of my favorite wordpress plugins Admin Management Xtended 2.0 was finally updated to...
Admin Management Xtended Plugin – One of the Best WordPress Plugins I cannot tell you enough how useful the “Admin Management Xtended Plugin” is for running a wordpress blog. I run...
My First Time Using WordPress Automatic Upgrade Plug-In I had downloaded the “WordPress Automatic Upgrade” Plug-in because I did want to simplify wordpress upgrades since I had never...
Using WordPress 2.7 Quick Edit I loved the Admin Management Xtended plug-in for WordPress 2.6 which allowed me to easily update categories and some data...
Migrating WordPress Blog to New Hosting Provider Part 1 – Backing Up Backing up your existing Wordpress Blog SQL Database and files is crucial to moving it to your new hosting provider....

If you enjoyed this post, subscribe to DragonBlogger.com

via FaceBook, Twitter, RSS or Email

or
Enter your email and subscribe now!

Written by dragonblogger (1110 Articles Published)

Working in the IT Industry for over 10 years and specializing in web based technologies. Dragon Blogger has unique insights and opinions to how the internet and web technology works. An Avid movie fan, video game fan and fan of trying anything and everything new.

Follow dragonblogger on Twitter @dragonblogger

Tags: cleanup wordpress revisions, optimize wordpress, optimize wordpress SQL, optimize wp database, wordpress, wordpress database, wordpress post revisions, WP-Optimize

3 Responses to “Optimize your WordPress Database with WP-Optimize”

Ralph (30 comments) Says:
October 16th, 2009 at 7:17 am
Thanks for the heads up. It would never have occurred to me that I need to clean up my database.
Ralph´s last blog ..Class
[Reply]
Mack from Las Vegas Condos (1 comments) Says:
October 19th, 2009 at 10:07 am
Hurray, now I dont have to get into my mysql for doing minor tweaks. I am glad that wordpress is improving day by day with all new includes and features. Their team has some real crackerjacks. Thanks for letting us know the existence of such an incredible plugin.
Regards,
Mack
Mack@Las Vegas Condos´s last blog ..Commercial Real Estate Bubble
[Reply]
Extreme John (43 comments) Says:
October 19th, 2009 at 6:53 pm
I might have to give this a shot on my tanning salon blog because that thing is terribly slow. I hate it.
Extreme John´s last blog ..Sunday Smash Link Luv, Twittley for Twitter, Yahoo Meme
[Reply]