List:General Discussion« Previous MessageNext Message »
From:Ed Carp Date:March 24 1999 5:51pm
Subject:Re: Isamchk on NT
View as plain text  
>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&

Thread
Isamchk on NTBarry24 Mar
  • Re: Isamchk on NTChristian Mack24 Mar
    • Re: Isamchk on NTBarry25 Mar
      • Re: Isamchk on NTMichael Widenius25 Mar
  • Isamchk on NTMichael Widenius24 Mar
Re: Isamchk on NTEd Carp24 Mar