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