Clean Up time

December 30th, 2008

Filed under: Technology

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.)


Related Post :

Why Don't you subscribe here :


Some like prose and some like verse,
Enjoy these lines that we disburse,
We do the stuff in fun,
And should you not like one,
Please feel free, below, to curse ......

10 Responses to “ Clean Up time ”

  1. Chetan
    December 30th, 2008 at 10:32 pm

    i did the same thing few days ago

    [Reply]

  2. Ashish Kalmegh
    December 30th, 2008 at 10:57 pm

    Abhi I need some help about managing the db of my site :P and will contact you via mail .

    [Reply]

  3. Amor
    December 31st, 2008 at 12:04 am

    I’ll be moving to a new server after the holidays and this will be of great help as I am backing up my database. Thanks for sharing Abi. Merry Christmas and a Happy New Year!

    [Reply]

  4. paras
    December 31st, 2008 at 12:53 am

    I really thank you ,to help me sort out my database problem !!!!

    keep ^^ buddy

    [Reply]

  5. Forsaken@Domain Marvelous
    January 1st, 2009 at 9:47 am

    Happy new Year, Abhishek. :)
    I came to your blog via dollarshower and find the articles really interesting. Hope to follow your blog in this new year.

    [Reply]

  6. Shirley
    January 2nd, 2009 at 8:13 am

    Yeh, its amazing how much junk some plugins put into the database. My database is not as large as yours, but I have cleaned it out a couple of times now.

    But now with the post revisions of these latest version, it has the potential to get really large.

    [Reply]

  7. Taris Janitens
    January 2nd, 2009 at 8:17 am

    Glad to hear you were able to take out the trash!! :)

    [Reply]

  8. Nihar
    January 2nd, 2009 at 10:59 am

    Thanks for the tip. I did this before. I have to do it again to remove all revision posts.

    btw, Wishing you a very happy new year!

    [Reply]

  9. p@r@noid
    January 6th, 2009 at 6:27 am

    Nice title for the post :)
    Wish you a great year ahead.

    [Reply]

  10. Mad Geek @ beingPC
    December 18th, 2009 at 7:02 pm

    Nice reading man……..

    [Reply]

Leave a Reply

« »