MySQL Forums
Forum List  »  MyISAM

Re: Error: Incorrect key file for table try to repair it
Posted by: Doug Hockinson
Date: December 09, 2011 07:48PM

Thank you. As you suggest, a rude shut-down was probably the cause of crashed tables, though the web host denies this could have happened. Generally speaking, as web page records, only 1 record is queried at a time, by its specific ID number.

The `deleted` field facilitates flagging records as deleted (instead of allowing the client to delete records by mistake). A system administrator strongly advised me to use a `deleted` field in tables where clients and/or non-technical people have access to data. Having adopted the usage of a `deleted` column, occasional client-orchestrated deletions become recoverable.

Similarly, the `hidden` field is manipulated when publicly available records are incomplete (not ready for prime time).

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Error: Incorrect key file for table try to repair it
3437
December 09, 2011 07:48PM


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.