Fixing Wordpress Database Errors

Have you ever seen an error like this show up on your Wordpress blog?

WordPress database error: [Can’t open file: ‘wp_comments.MYI’. (errno: 145)]
SELECT COUNT FROM wp_comments WHERE comment_approved = ‘0’

Well Steve Hetrick, the wizard from DataWordPro who manages my servers has the perfect solution…

Full Moon & candles,
magic times three
we summon the power
set database error free.

He says that the incantation works or that you can “just run the repair utility in Cpanel MySQL”. :-)

Popularity: 9% [?]

If you're new here, you may want to subscribe to my RSS feed or the No-Hype, No-BS, No Spam NPT newsletter. Thanks for visiting!

Comments

3 Responses to “Fixing Wordpress Database Errors”

Dewald - WordPress SEO on January 10th, 2008 9:20 am

Rosalind,

Believe me, I’ve tried different incantations, most of them having some very colorful language inserted, and the only thing that works is the repair. :)

Dewald

[Reply]

MyAvatars 0.2

Rosalind Gardner on January 10th, 2008 9:35 am

Hi Dewald,

So true. But it’s entirely worth saying the incantation for the smile it brings to your face. :-)

Cheers,
Ros

[Reply]

MyAvatars 0.2

Tonya on January 11th, 2008 10:14 am

Love this tip! Love the incantation as well… of course I would have to say something to that effect as I was pushing the little REPAIR button. lol.

It’s gonna help a lot of folks out to know this.. MYSELF included!!

It’s one of the reasons why I am still a faithful reader after all these years. I still learn something new every time the NPT comes out!!

Thanks Ros!!

Firefighter Tonya

[Reply]

MyAvatars 0.2

Got something to say?