running isamchk -eis and -o gives me following output.... 1) impossible length!!! does anyone got this before?
2) recordspace used: 100% ??? what does this mean? I have plenty of space on my hard drive # isamchk -o trend_data - recovering ISAM-table 'trend_data.ISM' Data records: 2371874 Found block with impossible length 4294967229 at 160392545; Skipped Data records: 2238318 # isamchk -eis trend_data Checking ISAM file: trend_data Key: 1: Keyblocks used: 50% Packed: 92% Max levels: 4 Key: 2: Keyblocks used: 60% Packed: 70% Max levels: 6 Key: 3: Keyblocks used: 49% Packed: 85% Max levels: 4 Key: 4: Keyblocks used: 49% Packed: 92% Max levels: 4 Key: 5: Keyblocks used: 83% Packed: 0% Max levels: 4 Key: 6: Keyblocks used: 51% Packed: 81% Max levels: 5 Total: Keyblocks used: 57% Packed: 80% Records: 2238318 M.recordlength: 72 Packed: 64% Recordspace used: 100% Empty space: 0% Blocks/Record: 1.00 Record blocks: 2238318 Delete blocks: 0 Record data: 163384748 Deleted data : 0 Lost space: 0 Linkdata: 6714954 User time 1576.95, System time 75.15 Maximum resident set size 0, Integral resident set size 0 Non physical pagefaults 0, Physical pagefaults 9912, Swaps 0 Blocks in 0 out 0, Messages in 0 out 0, Signals 0 Vouluntary context switches 10493, Invouluntary context switches 12475 __________________________________________________ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ --------------------------------------------------------------------- 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