DO NOT run myisamchk while the server is running.
lorenzo.kh wrote:
>Hi,
>I am using mysql 4.0.0-aplha on win 2000 professional.
>I install mysql in c:\mysql.
>I write a script ( customerscript.txt) and i save this script in
>c:\mysql\bin.
>The contents of customerscript.txt I will paste at the bottom of this mail.
>Then,I run my script at the command prompt.
>
>C:\mysql\bin>mysql < customerscript.txt
>
>And later on I try to check the table using the command below.
>And I get the error and warning.
>
>C:\mysql\bin>myisamchk ../data/test/customer
>Checking MyISAM file: ../data/test/customer
>Data records: 1 Deleted blocks: 0
>myisamchk: warning: 1 clients is using or hasn't closed the table properly
>- check file-size
>- check key delete-chain
>- check record delete-chain
>- check index reference
>- check data record references index: 1
>myisamchk: Can't unlock file (Errcode: 11)
>- check record links
>myisamchk: error: 11 when locking indexfile '../data/test/customer'
>
>Can anybody tell me what actually is this error?
>
>**************************************
>customerscript.txt
>**************************************
>use test;
>
>create table customer(
>id integer not null auto_increment primary key,
>name varchar(20),
>address varchar(150)
>);
>
>insert into customer (id,name,address) values
>(null,'Good customer','Good customer address');
>
>quit
>
>******************************************
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <mysql-thread116720@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
