Re: Corrupted .MYI file

2004-06-11 Thread Egor Egorov
There are too many reasons for that. Yes, users who press "reset" button, power outage, buggy hardward or OS, even corrupted MySQL builds may cause this to happen. Example: we often have this kind of troubles on FreeBSD 5.x on high load with big databases (tens of gigs). This happens because o

Re: Corrupted .MYI file

2004-06-10 Thread gerald_clark
Eric Lommatsch wrote: Hello, We had a situation over night where users were getting the error message: "[My SQL][ODBC 3.51 Driver][mysqld-4.0.13-nt] Can't open file: flex. MYI: [error : 145]" I found that .MYI file had become corrupted and I repaired the table and things are working as they should

Corrupted .MYI file

2004-06-10 Thread Eric Lommatsch
Hello, We had a situation over night where users were getting the error message: "[My SQL][ODBC 3.51 Driver][mysqld-4.0.13-nt] Can't open file: flex. MYI: [error : 145]" I found that .MYI file had become corrupted and I repaired the table and things are working as they should now. However t