From: Dan Nelson
Date: October 8 2002 5:32am
Subject: Re: how to check .MYI file withour shutdown database
List-Archive: http://lists.mysql.com/mysql/121578
Message-Id: <20021008053250.GB39947@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Oct 08), Patrick Hsieh said:
> Hello list,
> 
> Can I use myisamchk to check the index without shutdown the mysql
> server?

As long as your mysqld is running with locking enabled.  You can check
by running " SHOW VARIABLES LIKE 'skip_external_locking' ".  If it's
set to NO, you can run myisamchk while mysqld is running.

You might want to just use the "CHECK TABLE tablename" command, though,
which will always work.

-- 
	Dan Nelson
	dnelson@stripped