Hi. I am running MySQL 3.22.30, and am having trouble repairing a corrupted table with isamchk. Everything that I've tried either doesn't work, or wipes out all the data. Here's what I've tried so far:
*** isamchk -d guestbook ISAM file: guestbook Data records: 79764 Deleted blocks: 0 Recordlength: 376 Record format: Packed Using only 3 keys of 0 possibly keys table description: Key Start Len Index Type *** isamchk -e guestbook Checking ISAM file: guestbook Data records: 79764 Deleted blocks: 0 - check file-size - check delete-chain - check index reference - check records and index references isamchk: error: Found too long record at 0 ISAM-table 'guestbook' is corrupted Fix it using switch "-r" or "-o" *** isamchk -o guestbook isamchk: error: Can't lock indexfile of 'guestbook', error: 11 *** isamchk -r guestbook - recovering ISAM-table 'guestbook.ISM' Data records: 79764 Wrong bytesec: 1- 67- 0 at 0; Skipped Data records: 0 *** Any suggestions on how I can fix this? I would really appreciate it! Emily --------------------------------------------------------------------- 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
