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