List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:March 7 2001 5:16pm
Subject:Re: myisamchk errors
View as plain text  
In the last episode (Mar 07), Don Bowyer said:
> I recently upgraded our database from 3.22.32 to 3.23.32 We run a
> ISAM check every night, to check for db problems. Ever since I did
> the change, I get a email from the cron daemon like this:
> /usr/bin/myisamchk: MyISAM file /var/lib/mysql/cayn21/customers.MYI
> /usr/bin/myisamchk: warning: 1 clients is using or hasn't closed the table properly

The database is shut down when you do this, right?  You should really
never have to run myisamchk unless your server crashes a lot.  If you
don't want to shut down mysql to check tables, use the "CHECK TABLE"
mysql command.

	Dan Nelson
myisamchk errorsDon Bowyer7 Mar
  • Re: myisamchk errorsJoseph Bueno7 Mar
  • Re: myisamchk errorsDan Nelson7 Mar
    • Re: myisamchk errorsDon Bowyer7 Mar