Jump to content

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


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

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • 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.