mysql Wrong bytesec: 0-0-0 at linkstart: 0 I have several MySQL (MyISAM) tables that have been corrupted. Running CHECK TABLE mytable returns:

&gt; +-----------------+-------+----------+----------------------------------- |

&gt; clldata.mytable | check | warning  | Table is marked as crashed  

&gt; clldata.mytable | check | warning  | Size of datafile is: 4654864 Should be: 4602520

&gt; clldata.mytable | check | error    | Wrong bytesec: 0-0-0 at linkstart: 0

&gt; clldata.mytable |
&gt; check | error    | Corrupt                                            
&gt; |
&gt; +-----------------+-------+----------+-------------------------------------------------------+


4 rows in set (0.01 sec)

Running REPAIR TABLE mytable results in truncating about 90% of the rows that were originally in the table (and the size of the .MYD file also shrinks about 90%). And most of the remaining rows in mytable are clearly actually from one of the other corrupted tables.

Is there any hope of recovering data from such a table?
MY CONDOLENCES
MyISAM only caches index pages in the MyISAM Key Buffer. MyISAM never caches data. Notice how the messages from CHECK TABLE is only mentioning the datafile (that's the .MYD file) .
Since MyISAM data is fully reliant on the OS, rows of data are cached only in the OS. The MyISAM tables that are corrupt had open file handles when the crash happened (doesn't matter if mysqld crashed or the OS that crashed)
Recovery of the data is not possible.
FUTURE CONSIDERATIONS
Switching to InnoDB
In the future, please use InnoDB for all tables. InnoDB has a higher tolerance for crashes because it has transaction logs and double write buffers to recover data that was committed but not yet written as well as rollback segments and undo logs for rolling back uncommitted transactions.
Still Want to Use MyISAM

You should backups of the MyISAMs regularly
You should keep binary logs enabled, even if you don't use Replication. That way, you could use backups of the MyISAM tables and use the binary logs to replay INSERTs, UPDATEs, and DELETEs up to the point before the crash.
You should setup MySQL Repication so that the Slaves have good copies of the same tables

Give it a try!!!