RE: problems with mysql table

[Quentin Bennett <quentin.bennett@xxxxxxxxxxxxxx>]

Hi,

Try some of the more aggressive fixing options on isamchk - see the manual
for details.

Quentin

-----Original Message-----
From: Nuno Ferreira [mailto:nfaf@xxxxxxxxx]
Sent: Friday, 16 March 2001 10:39 a.m.
To: mysql@xxxxxxxxxxxxxxx
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:rider@xxxxxxxxxx
                      
http://www.lusoweb.pt
mailto:nuno.ferreira@xxxxxxxxx


---------------------------------------------------------------------
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-thread68389@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail
<mysql-unsubscribe-quentin.bennett=infinity.co.nz@xxxxxxxxxxxxxxx>
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 <mysql-thread68393@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php