[Mediawiki-l] Problems with repairing searchindex

[Michael Daly]

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