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
