-rw-rw---- 1 mysql mysql 100916 Mar 16 17:09 imp_addr.ISD
-rw-rw---- 1 mysql mysql 1024 Mar 16 17:09 imp_addr.ISM
-rw-rw---- 1 mysql mysql 8648 Mar 9 11:06 imp_addr.frm
I've been reading all the archieve files about a error i get when
trying to do any sql thing with a table.
check this out ...
mysql> select * from imp_addr;
ERROR 1030: Got error 127 from table handler
.... than .... i did what everyone says to do with a problem like this
...
isamchk -o imp_addr.ISM
- recovering ISAM-table 'imp_addr.ISM'
Data records: 1223
isamchk -r imp_addr.ISM
- recovering ISAM-table 'imp_addr.ISM'
Data records: 1223
.... and tried all the recovering methos available.
When i use the "-e" option with the "-r" the output is this ...
# isamchk -e imp_addr.ISM
Checking ISAM file: imp_addr.ISM
Data records: 1223 Deleted blocks: 0
- check file-size
- check delete-chain
- check index reference
- check records and index references
[root@thor horde]# isamchk -e -r -f imp_addr.ISM
- recovering ISAM-table 'imp_addr.ISM'
Data records: 1223
Found block with too small length at 297; Skipped
Found block with too small length at 1558; Skipped
Found block with too small length at 1955; Skipped
Found link that points at 1342181235 (outside data file) at 2254
Found block with too small length at 2504; Skipped
Found link that points at 1157628996 (outside data file) at 3601
Found link that points at 1258418244 (outside data file) at 3607
Found block with too small length at 4543; Skipped
Found block with too small length at 5053; Skipped
Found link that points at 1744831599 (outside data file) at 5644
Found link that points at 1107423343 (outside data file) at 5650
Found block with too small length at 5713; Skipped
Found block with too small length at 5719; Skipped
Found block with too small length at 6190; Skipped
Found block with too small length at 7072; Skipped
Found block with too small length at 7214; Skipped
Found block with too small length at 7293; Skipped
Found block with too small length at 7377; Skipped
Found block with too small length at 7880; Skipped
Found block with too small length at 8892; Skipped
Found block with too small length at 9286; Skipped
Found block with too small length at 9370; Skipped
Found block with too small length at 9439; Skipped
Found block with too small length at 9835; Skipped
Found block with too small length at 10649; Skipped
Found link that points at 1660946017 (outside data file) at 10788
Found block with too small length at 11290; Skipped
Found block with too small length at 12131; Skipped
Found block with too small length at 12137; Skipped
Found block with too small length at 12844; Skipped
Found block with too small length at 13878; Skipped
Found block with too small length at 14391; Skipped
Found block with too small length at 14475; Skipped
Found block with too small length at 15776; Skipped
Found block with too small length at 15927; Skipped
Found block with too small length at 16010; Skipped
Found block with too small length at 16080; Skipped
Found block with too small length at 16203; Skipped
Found block with too small length at 16209; Skipped
.... and it goes on and on for like more 20 lines or so ..
Can anyone help me ??? i really need this table recovered ...
Thanks
---
Nuno Ferreira
mailto:[EMAIL PROTECTED]
http://www.lusoweb.pt
---
---------------------------------------------------------------------
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
