Blog upgraded, finally

23 Dec, '09

Due to a 6-year-old database (dinosaur by blogging’s standard) which was subjected to hundreds of plugins and optional component installs and uninstalls, plug various other caching and theme components whose developers thought it best to write their preferences in the database and neglected to remove those entries on uninstallation, the site’s database got to be a huge 310MB in size! Being fat, I can tell you, is not a good idea at the best of times.

So, days after the installation, I finally got the time to deal with this properly. For those interested who might be in the same situation, my remedial steps to properly upgrade to WordPress version 2.9 from 2.8 are as follows:

1. I manually went in and removed the no longer needed tables (after backing up the database of course)
2. I manually edited the db version number in the options table (as given above, thanks!) to 12329 to force going beyond the forced upgrade page
3. I went to the admin panel, downloaded, installed and activated the "Clean Options" plugin.
4. I got the plugin to remove all the hash rss entries (over 8 thousand of them!)
5. I got the plugin to evaluate all the remaining entries in the table to determine the most likely unneeded entries and double checked them all. Selected the ones I know to be unneeded and deleted them.
6. The above operation reduced the database size from 310MB down to 58MB!! Serious weight loss ;)
7. I re-edited the options value to put in the old database version of 11548
8. Went to the Admin panel again /wp-admin
9. Clicked the "upgrade database" button, and then within seconds the upgrade was reported successful and I have my blog back!

I’m so glad that the site is up and running again. I am also even happier that the database has finally slimmed down which seems to have affected the response of the site too to the better.

Silver lining? I guess so.

Filed in: Technology
Tagged with:

Comments (7)

Trackback URL | Comments RSS Feed

  1. BuZain says:

    Congrats on the upgrade my friend. the site feels snappier indeed.

    There is a bit of a glitch in the layout that I noticed on ubuntu linux 9.04 using firefox 3.0.16 as you see here

    It looks fine though on windows 7 using firefox 3.5.6 and on on ubuntu 9.10 using firefox 3.5.5

    • mahmood says:

      Thanks BuZain. It looks like it might have been a javascript glitch as that screwed up the video widget display and that affected the whole sidebar.

  2. Dear Mr. Mahmood,

    I tried to add my new blog on the aggregator but with no success. I found ” error” in all the attempts.

    I have also sent you an email on this issue.

    I would be grateful if you can add the blog to the aggregator.

    Much appreciated.

    Thanks &Regards

  3. J.M. Heinrichs says:

    As long as it runs in Safari, on Snow LEopard, what other concerns need one have?


  4. dear Mr. Mahmood,

    I am sorry but i still can not add my blog on the blog roll. Please advise.

    i am grateful.

Back to Top