WordPress database error: [Can't open file: 'wp_comments.MYI'. (errno: 145)]
9 Comments Published August 29th, 2007 in Software Tags: .Today I got this error message on my blog.
WordPress database error: [Can't open file: 'wp_comments.MYI'. (errno: 145)]
It’s not the first time. Last time I solved quickly searching on google what the "errno: 145" is. I found it is a database corruption problem.
I don’t know why that happened, I guess spammers are exaggerating in commenting my blog. But I know the solution:
$ mysql -u user_name -h host_name -p database_name mysql> repair table wp_comments;
Saved here, for future problems, for people in troubles.
9 Responses to “WordPress database error: [Can't open file: 'wp_comments.MYI'. (errno: 145)]”
- 1 Pingback on Sep 11th, 2007 at 04:28
- 2 Pingback on Sep 11th, 2007 at 06:13
- 3 Pingback on Sep 11th, 2007 at 14:15
- 4 Pingback on Sep 12th, 2007 at 08:33
- 5 Pingback on Nov 19th, 2007 at 09:30
- 6 Pingback on Dec 14th, 2007 at 00:15
Leave a Reply
Search
Calendar
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Jul | Sep » | |||||
| 1 | 2 | 3 | 4 | 5 | ||
| 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| 27 | 28 | 29 | 30 | 31 | ||
Follow me
Archives
Categories
Tag Cloud
Android API Bash Bios CSS Development Eclipse Encription Error Handling Font Git Google GWT Hardware How-To HTML Installation iPod Java JavaScript Karmic Linux Lucks MacBook Open Source Opinion OSX Pitfalls Pkg Practices Python Resume Security Software Suspend TDD Testing Tools Top Down Tricks Ubuntu Uninstall Wakup On Lan Web Workaround
WP Cumulus Flash tag cloud by Roy Tanck and Luke Morton requires Flash Player 9 or better.
Blog License
Blogs I like
Books on the desk
Friends' Blogs
- Antonio Terreno & Valter Bernardini
- Bruno Bossola
- Daniele Galluccio
- Domenico Ventura
- Ed Schepis
- Fabrizio Gianneschi
- Luca Grulla
- Luigi Zanderighi
- Marcello Teodori
- Mida Boghetich
- Muralidharan Chandrasekaran
- Piero Ricca
- Renzo Borgatti
- Simone Bordet
- Simone Bruno
- Uberto Barbini
- Valvolog
- Webtide blogs (Greg Wilkins & Jan Bartel)
Links
Other Stuff
Thanks a million!
Cheers,
Og
Fantastic fix! How did you figure this out!
Thanks for the fix!