countrydj Posted April 15, 2014 Share Posted April 15, 2014 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 tableI 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 ??? Quote Link to comment https://forums.phpfreaks.com/topic/287780-incorrect-key-file-for-table-vendors-try-to-repair-it/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.