https://business.forums.bt.com/t5/Archive/Repair-Mysql-table-corruption/m-p/48686#M14797 <P>User is reporting a corrupted table<BR /><BR />/var/lib/mysql/my_forum/my_search_wordlist<BR /><BR />I manage to repair using myisamchk -r /var/lib/mysql/my_forum/my_search_wordlist.MYI<BR />- recovering (with sort) MyISAM-table '/var/lib/mysql/my_forum/my_search_wordlist.MYI'<BR />Data records: 320451<BR />- Fixing index 1<BR />- Fixing index 2<BR /><BR />However, fixing using mysqlcheck still triggers an error:<BR /><BR />[root@myserver ~]# mysqlcheck --auto-repair -o -umy_forum -p****** my_forum my_search_wordlist<BR />my_forum.my_search_wordlist<BR />Error : Incorrect key file for table 'my_search_wordlist'; try to repair it<BR />error : Corrupt<BR /><BR />Repairing tables<BR />my_forum.my_search_wordlist<BR />Error : Incorrect key file for table 'my_search_wordlist'; try to repair it<BR />error : Corrupt<BR /><BR /><BR />Any other ideas:<IMG border="0" src="http://imagicon.info/cat/12-1/text-smiley.png" /></P> Sat, 15 Dec 2012 15:35:38 GMT orthohin 2012-12-15T15:35:38Z https://business.forums.bt.com/t5/Archive/Repair-Mysql-table-corruption/m-p/48686#M14797 <P>User is reporting a corrupted table<BR /><BR />/var/lib/mysql/my_forum/my_search_wordlist<BR /><BR />I manage to repair using myisamchk -r /var/lib/mysql/my_forum/my_search_wordlist.MYI<BR />- recovering (with sort) MyISAM-table '/var/lib/mysql/my_forum/my_search_wordlist.MYI'<BR />Data records: 320451<BR />- Fixing index 1<BR />- Fixing index 2<BR /><BR />However, fixing using mysqlcheck still triggers an error:<BR /><BR />[root@myserver ~]# mysqlcheck --auto-repair -o -umy_forum -p****** my_forum my_search_wordlist<BR />my_forum.my_search_wordlist<BR />Error : Incorrect key file for table 'my_search_wordlist'; try to repair it<BR />error : Corrupt<BR /><BR />Repairing tables<BR />my_forum.my_search_wordlist<BR />Error : Incorrect key file for table 'my_search_wordlist'; try to repair it<BR />error : Corrupt<BR /><BR /><BR />Any other ideas:<IMG border="0" src="http://imagicon.info/cat/12-1/text-smiley.png" /></P> Sat, 15 Dec 2012 15:35:38 GMT https://business.forums.bt.com/t5/Archive/Repair-Mysql-table-corruption/m-p/48686#M14797 orthohin 2012-12-15T15:35:38Z