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 <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
