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