Database Restored

October 19th, 2007 at 13:07 · Filed Under Blogging, Computing, Web 

I don’t exactly know for sure but all my WordPress databases were having some hiccups. When I visited all my sites, it displayed “WordPress database error: [got error 28 from storage engine]“.

That sounded like some kind of storage error. Have I run out of disk space? Nope. I am only using 200+MB of disk space out of 400GB of total disk space. A search on the web had suggested that a MySQL database problem had occurred. MySQL can become overburdened after many long hard days of fetching and editing tables and created overhead. This is like having defragmentation of hard disk space. Data stored in this defragmented space is no longer continuos.

I quickly followed the repair instruction found on Paul Stamatiou‘s blog. Unfortunately, I could not start phpMyAdmin either. It gave me some error messages. From the error messages, it look like I had run out of disk space on /tmp. I was helpless so I turned to my WSP.

Andrey, the support of my WSP, and the administrators had done a great job. They fixed my problem under 15 minutes while I was interacting with Andrey. This is, perhaps, my best experience with all the WSP so far. I hope they keep up with their good work. Two thumbs up for them.

Tags:

Comments

Leave a Reply