welcome to the craptacular world of MySQL :P yes, power interruptions can do that.
try an isamchk or myisamchk that usually can recover something from the crap that MySQL leaves behind... On 2/10/07, Roberto Verzola <[EMAIL PROTECTED]> wrote:
error : Can't open file: 'phones.MYI' (errno: 145) nocheats.provinces Table is already up to date nocheats.queue Table is already up to date nocheats.reports error : Can't open file: 'reports.MYI' (errno: 145) nocheats.results Table is already up to date nocheats.towns Table is already up to date nocheats.unconfirmed error : Can't open file: 'unconfirmed.MYI' (errno: 145) So the above .MYI files were really corrupted. I really would like to know how the files were corrupted. The top suspect seems to be the power outage. I just want to make sure I didn't miss anything.
_________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List [email protected] (#PLUG @ irc.free.net.ph) Read the Guidelines: http://linux.org.ph/lists Searchable Archives: http://archives.free.net.ph
