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
