Some minor edit to this blog, save, and instead of the usual messages I get an error message  incorrect key file for table ./database/serendipity_entries.MYI; try to repair it! Collateral damage: text has not been saved.

I tried Google to find some attempts to downplay the issue, possibly just a hd completly used. But this is not what has happened for me, tmpfs still has 505MB left and the Index file mentioned in the error report is just 320Kb. So I search on and find check table und repair table. The documentation recommends a prior backup. then:

mysql -u root -p
use database;

CHECK TABLE serendipity_entries;

 
(output denotes the table as corrupt)
 
REPAIR TABLE serendipity_entries;
 
+------------------------------+--------+----------+----------+
 
| Table                        | Op     | Msg_type | Msg_text |
 
+------------------------------+--------+----------+----------+
 
| web31db1.serendipity_entries | repair | status   | OK       |
+------------------------------+--------+----------+----------+
 
and that's it, savine works again.


Trackbacks


Trackback specific URI for this entry
    No Trackbacks

Comments


    No comments

Add Comment

Enclosing asterisks marks text as bold (*word*), underscore are made via _word_.
Standard emoticons like :-) and ;-) are converted to images.
E-Mail addresses will not be displayed and will only be used for E-Mail notifications.

To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly.
CAPTCHA