# 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