Re: Error code 127: Record-file is crashed.

[Andrew Dodson]

Hi,
Ingo, my versions MySQL 4.1.11-log bundled and running on Fedora Core.

The repair table worked before when i was using the MySQL Query Browser, saying the usual 'Repair, status, Ok'. However I have just ran the repair statement from the command shell and my sqg is now
<pre>

+-------------------------+--------+----------+------------------------------------------------+
| Table                   | Op     | Msg_type | Msg_text                                       |
+-------------------------+--------+----------+------------------------------------------------+
| booksharp.book_allmedia | repair | warning  | Number of rows changed from 2336264 to 1342426 |
| booksharp.book_allmedia | repair | status   | OK                                             |
+-------------------------+--------+----------+------------------------------------------------+
2 rows in set (6 min 0.73 sec)

</pre>

The number of rows should be 2336264,

Ingo was this similar to your problem.