MySQL Forums
Forum List  »  Data Recovery

Database faulty: Incorrect key file for table 'vendors'; try to repair it
Posted by: John Craven
Date: April 15, 2014 05:46AM

I have a small web site for advertising businesses in Lancashire (England)
Local services and facilities in Lancashire, UK.
The database has two tables:
topics and vendors.
The topics table holds all the types of business, and is OK.
The vendors table holds all the businesses (e.g. Joe Blogs. Joiner, Adress, etc) and is faulty:
Incorrect key file for table 'vendors'; try to repair it
Code:
mysql> check table vendors;
+----------------------+-------+----------+----------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+----------------------+-------+----------+----------------------------------------------------------+
| inlancashire.vendors | check | Error | Incorrect key file for table 'vendors'; try to repair it |
| inlancashire.vendors | check | error | Corrupt |
+----------------------+-------+----------+----------------------------------------------------------+
2 rows in set (0.00 sec)

mysql>
Code:
mysql> repair table vendors;
+----------------------+--------+----------+----------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+----------------------+--------+----------+----------------------------------------------------------+
| inlancashire.vendors | repair | Error | Incorrect key file for table 'vendors'; try to repair it |
| inlancashire.vendors | repair | error | Corrupt |
+----------------------+--------+----------+----------------------------------------------------------+
2 rows in set (0.00 sec)

mysql>
This does not repair the table

I also tried:
Code:
myisamchk vendors
Checking MyISAM file: vendors
Data records: 3029 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check record links
and
Code:
myisamchk -r vendors
- recovering (with sort) MyISAM-table 'vendors'
Data records: 3029
- Fixing index 1
and then
Code:
myisamchk vendors
Checking MyISAM file: vendors
Data records: 3029 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check record links
'myisamchk -r vendors' indicated that it was fixing the table, but it didn't.

I have been Googling this problem for quite a few hours now, and cannot find a solution.

Can anybody help ???

The MAN, The MYTH, The LEGEND:
John C
________________________________
Support your local Country Music Club

Options: ReplyQuote


Subject
Views
Written By
Posted
Database faulty: Incorrect key file for table 'vendors'; try to repair it
2699
April 15, 2014 05:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.