List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:August 9 2001 7:06pm
Subject:Re: myisamchk reports tables not closed properly
View as plain text  

harrison@stripped wrote:

>> Description:
> 
> 	
> 
> 	I'm new to MySQL, and am porting an application from msql. Apologies
> 	in advance for blatant ignorance on my part.
> 
> 	Apparantly the code that increments the counter on whether
> 	a table has been modified is broken. myisamchk reports that:
> 
> 	"myisamchk: warning: 1 clients is using or hasn't closed the 
> 	table properly"
> 
> 	when I don't think it should. Also, note that the configuration
> 	is somewhat non-standard.
> 
> 
>> How-To-Repeat:
> 
> 	
> 
> mysqladmin create foo
> echo "CREATE TABLE try ( user CHAR(9), message TEXT) \g" | mysql foo
> echo "INSERT INTO try VALUES ('hi', 'sailor') \g" | mysql foo
> myisamchk /usr/local/storm/MySQL/var/foo/*.MYI
> 
> 

Don't run myisamchk while the server is running.


-- 
Gerald L. Clark
gerald_clark@stripped

Thread
myisamchk reports tables not closed properlyharrison9 Aug
  • Re: myisamchk reports tables not closed properlyGerald Clark9 Aug