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
- Android (3)
- Apple (26)
- Books (7)
- Eclipse (14)
- Errors (3)
- Firefox (7)
- Git (2)
- Hardware (16)
- Horror Code (8)
- Internet (18)
- Java (98)
- JavaScript (9)
- Life, universe and everything (45)
- Lifehacks (25)
- Linux (50)
- Opinions (25)
- OSX (4)
- Python (1)
- Software (27)
- Speeches and Conferences (8)
- Unix (3)
- Web (21)
- Windows (19)
Tag Cloud
Android apple architecture Bash colors configuration CSS Development Düsseldorf Eclipse germany Git Google Hardware hdr How-To Java JAXB job junit Karmic Linux MacBook music night Open Source Opinion oracle OSX patterns Pitfalls Practices Resume Security Software Suspend TDD Testing tip tonemapped Tricks Ubuntu video Web XML
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!