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