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 ??? 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
Archived
This topic is now archived and is closed to further replies.