Sir, I looked quickly through the mass of data supplied below, and it
looks like you only tried myisamchk with the -r -q option
combination. Try it with just -r. If that doesn't work, try it with
-o. If that doesn't work, restore from backup.
Got backup?
Bob Hall
>Antonio gulli wrote:
>
> > Any help is appreciated
> >
> > Welcome to the MySQL monitor. Commands end with ; or \g.
> > Your MySQL connection id is 158 to server version: 3.23.36-log
> >
> > myisamchk -V
> > myisamchk Ver 1.45 for pc-linux-gnu at i686
> >
> > a) Trying a recovery.....
> >
> > myisamchk -r -q -Osort_key_blocks=16 keywords
> > - check key delete-chain
> > - check record delete-chain
> > - recovering (with keycache) MyISAM-table 'keywords.MYI'
> > Data records: 2062985
> > 7000
> > [root@ideare queries]# myisamchk -r -q -Osort_key_blocks=16
> > -Okey_buffer_size=256M -Oread_buffer_size=256M -Osort_buffer_size=256M
> > keywords
> > - check key delete-chain
> > - check record delete-chain
> > - recovering (with keycache) MyISAM-table 'keywords.MYI'
> > Data records: 2062985
> >
> > ---------
> >
> > - check key delete-chain
> > - check record delete-chain
> > - recovering (with keycache) MyISAM-table 'keywords.MYI'
> > Data records: 2062985
> >
> > b) Trying a check ....
> >
> > Database changed
> > mysql> CHECK TABLE keywords;
> >
>+------------------+-------+----------+-------------------------------
>---------+|
> > Table | Op | Msg_type |
> > Msg_text
> >
>|+------------------+-------+----------+------------------------------
>----------+|
> > keywords | check | error | Key in wrong position at page
> > 24942592 || queries.keywords | check | error |
> > Corrupt
> >
>|+------------------+-------+----------+------------------------------
>----------+2
> > rows in set (10.12 sec)
> >
> > yisamchk -a -Osort_key_blocks=16 -Okey_buffer_size=256M
> > -Oread_buffer_size=256M -Osort_buffer_size=256M keywords
> > \Checking MyISAM file: keywords
> > Data records: 2062985 Deleted blocks: 0
> > myisamchk: warning: Table is marked as crashed
> > - check file-size
> > - check key delete-chain
> > - check record delete-chain
> > - check index reference
> > - check data record references index: 1
> > - check data record references index: 2
> > - check data record references index: 3
> > myisamchk: error: Key in wrong position at page 24942592
> > - check record links
> > myisamchk: error: Keypointers and record positions doesn't match
> > MyISAM-table 'keywords' is corrupted
> >
> > 3) Describe this table ...
> >
> > myisamchk -dvv keywords
> >
> > MyISAM file: keywords
> > Record format: Packed
> > Character set: latin1 (8)
> > File-version: 1
> > Creation time: 2001-03-28 10:02:22
> > Recover time: 2001-03-29 11:01:02
> > Status: crashed
> > Data records: 2062985 Deleted blocks: 0
> > Datafile parts: 2062985 Deleted data: 0
> > Datafile pointer (bytes): 4 Keyfile pointer (bytes): 4
> > Datafile length: 79274620 Keyfile length: 99454976
> > Max datafile length: 4294967294 Max keyfile length: 4398046510079
> > Recordlength: 281
> >
> > table description:
> > Key Start Len Index Type Rec/key Root
> > Blocksize
> > 1 5 254 fulltext varchar packed 0
> > 26022912 2048
> > 1 4 float 0
> > 2 266 16 multip. char packed stripped NULL 0
> > 56983552 1024
> > 3 2 255 multip. char packed stripped NULL 0
> > 30499840 2048
> >
> > Field Start Length Nullpos Nullbit Type
> > 1 1 1
> > 2 2 255 1 1 no endspace
> > 3 257 4 1 2 no zeros
> > 4 261 2 1 4 no zeros
> > 5 263 3 1 8 no zeros
> > 6 266 16 1 16 no endspace
> >
> > 4) Re-check it ....
> >
> > mysql> CHECK TABLE keywords;
> >
>+------------------+-------+----------+-------------------------------
>---------+|
> > Table | Op | Msg_type |
> > Msg_text
> >
>|+------------------+-------+----------+------------------------------
>----------+|
> > keywords | check | warning | Table is marked as
> > crashed || keywords | check | error | Key in
> > wrong position at page 74375168 || queries.keywords | check | error |
> > Corrupt
> >
>|+------------------+-------+----------+------------------------------
>----------+3
> > rows in set (9.12 sec)
> >
> > 5) http://www.mysql.com/doc/R/e/Repair.html Stage 3: Difficult repair
> >
> > francesca> mysql queries
> > mysql> SET AUTOCOMMIT=1;
> > mysql> TRUNCATE TABLE keywords;
> > mysql> quit
> >
> > myisamchk -r -q -Osort_key_blocks=16 -Okey_buffer_size=256M
> > -Oread_buffer_size=256M -Osort_buffer_size=256M keywords
> > - check key delete-chain
> > - check record delete-chain
> > - recovering (with keycache) MyISAM-table 'keywords.MYI'
> > Data records: 0
> >
> > mysql> use queries;
> > Database changed
> > mysql> CHECK TABLE keywords;
> >
>+------------------+-------+----------+-------------------------------
>---------+|
> > Table | Op | Msg_type |
> > Msg_text
> >
>|+------------------+-------+----------+------------------------------
>----------+|
> > keywords | check | error | Key in wrong position at page
> > 65639424 || queries.keywords | check | error |
> > Corrupt
> >
>|+------------------+-------+----------+------------------------------
>----------+2
> > rows in set (9.71 sec)
> >
> > mysql> describe keywords;
> > ERROR 1016: Can't open file: 'keywords.MYD'. (errno: 145)
>
>
>---------------------------------------------------------------------
>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
Know thyself? Absurd direction!
Bubbles bear no introspection. -Khushhal Khan Khatak
---------------------------------------------------------------------
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