This is time to say bye to year 2008. And count up remaining in Dasvidaniya Style. Long road to go yet, just checked my Phpmyadmin for regular backup after a long time. the Backup was around 31 MB !! Confused ?? I was too. Most of memory was consumed by Statpress plugin and few other plugins that i used some months back.
Deletion of those plug-in, doesn’t delete there tables from database, so the garbage was still there. just cleaned those old tables. saved my lots of memory.
Heres a little SQL trick I found from Devils Workshop , to clean up the revised versions of the post we publishes. Little change in the SQL Command from me as given SQL command was giving error.
DELETE FROM `wp_posts`WHERE `post_type` LIKE ‘revision’;
Now my Database is just 1.5 MB, Good to hear (Not only for my server but also for speed of blog access.)