Jump to content

Incorrect key file for table 'vendors'; try to repair it


countrydj

Recommended Posts

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 ???

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.