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
