Nuno Ferreira wrote:
>
> Hi again.
>
> 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
>
> --
Looks to me like you have exceded the 2G File size limit.
You need Myisam tables, and a filesystem that supports files larger than
2G.
---------------------------------------------------------------------
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
