Hi again ....
No .. not really that big (the table)
-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
100K the ISD part ... anyway i have tried to "> imp_addr.ISD"
to put it 0 lenght ... but no luck :(((
On Fri, 16 Mar 2001, Gerald L. Clark wrote:
> 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
>
>
>
--
---
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
