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.
Don't have time to check my blog? Get a weekly email with all the new posts. This is my personal blog, so obviously it is 100% spam free.
This entry was posted on Tuesday, December 19th, 2006 at 3:45 pm and is filed under Life. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.