Shannon Adams wrote:
mysql> show columns from searchindex; ERROR 1016 (HY000): Can't open file: 'searchindex.MYI' (errno: 145)
If you have a database prefix set when you installed the wiki, the table name is prefix_searchindex. For example, if you set the prefix to foo, the table name is foo_searchindex.
mysql> repair wiki_it.searchindex; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'wiki_it.searchindex' at line 1
Ditto and what Brion wrote.
Mike