It’s time to say goodbye to the year 2008 and count what remains in Dasvidaniya style. Long road ahead yet — I just checked my phpMyAdmin for regular backup after a long time. The backup was around 31 MB! Confused? I was too. Most of the memory was consumed by the Statpress plugin and a few other plugins I had used some months back.
Deleting those plugins doesn’t delete their tables from the database, so the garbage was still there. I just cleaned out those old tables and saved a lot of memory.
Here’s a little SQL trick I found from Devil’s Workshop to clean up the revised versions of published posts. I made a small change to the SQL command since the original was giving an error.
DELETE FROM `wp_posts` WHERE `post_type` LIKE ‘revision’;
Now my database is just 1.5 MB — good news (not only for my server but also for the speed of blog access).