I logged on to my blog to post today to find I got some error about my database.
WordPress database error: [Can't open file: 'blog_comments.MYI' (errno: 144)]
SELECT COUNT(*) FROM blog_comments WHERE comment_approved = ‘0′
Corrupt table but I couldn’t go into phpMyAdmin to repair it and it errored out. So I had to go in to the command line and repair it that way.
mysql -u dbuname -h dbhost -p dbname;
repair table blog_comments;
Which sorted it and I could finally log in. To find 148 comments had got past Akismet in the past few days. Awesome.
Metadata
This entry was posted on Tuesday, December 19th, 2006 at 3:45 pm and is filed under General. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
December 20th, 2006 at 3:53 pm
Yeah, I was going to suggest a command line repair when I saw the error, but figured you would sort it out
As for Akismet, its been hit pretty hard lately. While nothing has got through my filters I got over 1000 spam messages caught in 3 days.