RE: problems with mysql table
Hi, Try some of the more aggressive fixing options on isamchk - see the manual for details. Quentin -Original Message- From: Nuno Ferreira [mailto:[EMAIL PROTECTED]] Sent: Friday, 16 March 2001 10:39 a.m. To: [EMAIL PROTECTED] Subject: problems with mysql table Hi there I have a problem with one mysql table and i don't know how to solve it .. the table has some important stuff. when i make a select this is what happens mysql select * from imp_addr; ERROR 1030: Got error 127 from table handler mysql and isamchk isamchk imp_addr.ISM Checking ISAM file: imp_addr.ISM Data records:1223 Deleted blocks: 0 - check file-size - check delete-chain - check index reference - check record links Can anyone help me on this ??? Thanks :) -- Nuno Ferreira AKA |rider http://rider.lusoweb.pt mailto:[EMAIL PROTECTED] http://www.lusoweb.pt mailto:[EMAIL PROTECTED] - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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
RE: problems with mysql table
# isamchk -a -d -e -f -i -l -o imp_addr.ISM ISAM file: imp_addr.ISM Data records: 1223 Deleted blocks: 0 Recordlength:25 Record format: Packed table description: Key Start Len Index Type User time 0.00, System time 0.00 Maximum resident set size 0, Integral resident set size 0 Non physical pagefaults 16, Physical pagefaults 51, Swaps 0 Blocks in 0 out 0, Messages in 0 out 0, Signals 0 Vouluntary context switches 0, Invouluntary context switches 0 - Anymore available STRONG options i can use ??? cause i think that ones are about all ... and still no good luck :( regards On Fri, 16 Mar 2001, Quentin Bennett wrote: Hi, Try some of the more aggressive fixing options on isamchk - see the manual for details. Quentin -Original Message- From: Nuno Ferreira [mailto:[EMAIL PROTECTED]] Sent: Friday, 16 March 2001 10:39 a.m. To: [EMAIL PROTECTED] Subject: problems with mysql table Hi there I have a problem with one mysql table and i don't know how to solve it .. the table has some important stuff. when i make a select this is what happens mysql select * from imp_addr; ERROR 1030: Got error 127 from table handler mysql and isamchk isamchk imp_addr.ISM Checking ISAM file: imp_addr.ISM Data records:1223 Deleted blocks: 0 - check file-size - check delete-chain - check index reference - check record links Can anyone help me on this ??? Thanks :) -- --- Nuno Ferreira mailto:[EMAIL PROTECTED] http://www.lusoweb.pt --- - 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