Hello
I have a table named 'content' keeping parafraph text of some articles.
Suddenly I get the message
mysql> select id,article_id,p_order from content;
ERROR 1030: Got error 127 from table handler
mysql> delete from content;
I do have backup.
I cannot repair using manual instructions...
Any ideas ???
Table structure
+------------------+--------------------+------+-----+-------------+-------------------------+
| Field | Type | Null | Key | Default | Extra
|
+------------------+--------------------+------+-----+-------------+-------------------------+
| id | int(11) | | PRI | 0 |
auto_increment |
| article_id | int(11) | | | 0 |
|
| paragraph | text | YES | | NULL |
|
| p_title | varchar(250) | YES | | NULL |
|
| p_order | int(11) | | | 1 |
|
| p_img | varchar(150) | YES | | NULL |
|
| p_img_alt | varchar(150) | YES | | NULL |
|
| p_img_align | tinyint(4) | YES | | NULL |
|
+-------------+--------------+------+-----+---------+----------------+
8 rows in set (0.00 sec)
Part 1: Checking
[root@cosmos care]# isamchk -e content.ISM
Checking ISAM file: content.ISM
Data records: 269 Deleted blocks: 1
- check file-size
- check delete-chain
- check index reference
- check records and index references
isamchk: error: Recordlink that points outside datafile at 547
ISAM-table 'content.ISM' is corrupted
Fix it using switch "-r" or "-o"
Part 2: Easy safe repair.
[root@cosmos care]# isamchk -r -q content.ISM
- check delete-chain
- recovering ISAM-table 'content.ISM'
Data records: 269
- Fixing index 1
Found block with impossible length 6221715 at 3629; Skipped
ISAM-table 'content.ISM' is not fixed because of errors
[root@cosmos care]#
Part 3:; Hard repair.
[root@cosmos care]# isamchk -r -q content.ISM
- check delete-chain
- recovering ISAM-table 'content.ISM'
Data records: 0
- Fixing index 1
Found block with impossible length 6221715 at 3629; Skipped
ISAM-table 'content.ISM' is not fixed because of errors
Thanks
Christos Pontikis
http://www.medisign.gr
