MySQL Forums
Forum List  »  MyISAM

HELP: Table is now full of nulls, but MYD file still contains the data
Posted by: Robin Massart
Date: February 18, 2009 11:03AM

Hi there,

I am having problems with a MyIsam table. It seems to have become corrupted. One column in one table is all of a sudden returning null for 90% of the values. However the MYD file for that table seems large enough and opening it indicates that there is data in the column now showing all the nulls.

I have copied the MYD file to a new database on a separate machine. And have the same problem. Further, repairing the table results in the MYD file being cleared as well (ie it becomes very small - as would be expected if the column in question were null for all rows).

Is there anyway of restoring data from a MYD table or somehow reading that file in via SQL or some MySql command?

Thanks very much for any help.

Regards,
Robin

Options: ReplyQuote


Subject
Views
Written By
Posted
HELP: Table is now full of nulls, but MYD file still contains the data
3289
February 18, 2009 11:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.