>Did you stop mysql before running isamchk?
>Or did you do a 'mysqladmin refresh' before isamchk?
>Did you prevent any other user from using mysql while running isamchk?
>
>If not, that's your problem.
Here's a script that I use (checkdb) that shuts everything down, runs
isamchk, then brings MySQL back up...
#! /bin/sh
cd /usr/local/var
echo Shutting down MySQL...
mysqladmin shutdown
N=1
while [ $N -gt 0 ]
do
N=`ps ax|grep mysqld|grep -v grep|wc -l`
N=`echo $N`
echo Still $N threads running...
sleep 1
done
echo Checking databases:
for i in `find . -name '*.ISM' -print`
do
echo Checking $i
isamchk -s -f $i
done
echo Done - restarting MySQL
safe_mysqld&
