hi listers i've upgraded my mysql env from 3.23.53 to 4.0.13. also, i changed os from m$ to rh 7.3. what did not change was h/ware.
since the upgrade, i often get the error message "table is marked as crashed and should be repaired". (errno 145). i then run myisamcheck --auto-repair to fix the problem but this is a reactive. what switches can i set on mysqld to trace the cause of this problem? to handle to symptom, i've set myisam_recover_option=backup,force in my.cnf this morning so hopefully the problem does not re-occur, though i'm sure sure if this will work tks _________ _______ _ __ /___ ___/ / ___ / / \ / / / / / / / / / ^ v / / / / /__/ / / / \/ / / /_ / /______ / /_ / /_ / Cell: 083 440 2213 Ph: 021 980 4969