Hi,
     I seem to be having a problem with a corrupt table.

# myisamchk --fast --silent /var/lib/mysql/HNCandidate/Candidate.MYI

myisamchk: MyISAM file /var/lib/mysql/HNCandidate/Candidate.MYI
myisamchk: warning: 1 clients is using or hasn't closed the table properly
myisamchk: error: Recordlink that points outside datafile at 759250856
MyISAM-table '/var/lib/mysql/HNCandidate/Candidate.MYI' is corrupted
Fix it using switch "-r" or "-o"

After getting this message I ran...
myisamchk -r --safe-recover --silent --sort-index  -O sort_buffer_size=16M 
/var/lib/mysql/HNCandidate/Candidate.MYI

it cleared the message but 5mins later I had the error again.

should i try the "Difficult repair"?

shell> mysql db_name
mysql> SET AUTOCOMMIT=1;
mysql> TRUNCATE TABLE table_name;
mysql> quit

thanks
ashley

Redhat 7.0 / Mysql 3.23.32


Ashley Pestkowski - Head of IT
dn1.net - Chelsea Chambers - 262a Fulham Road, London, SW10 9EL

[EMAIL PROTECTED]
http://www.dn1.net

Tel:     0207 849 3668
Fax:    0207 849 3670



---------------------------------------------------------------------
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

Reply via email to