From: Ed Carp
Date: March 24 1999 5:51pm
Subject: Re: Isamchk on NT
List-Archive: http://lists.mysql.com/mysql/914
Message-Id: <002001be761e$fba762a0$74c9a8c0@traveler.airmail.net>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

>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&