I posted a question last night regarding three letter searching. I found a thread from last month that detailed what I needed to do. I am down to repairing the searchindex table, but I am getting errors. The commands I used are below.
mysql --user=root --password=***** wiki_it
mysql> show tables; <shows all tables following be 35 rows in set (0.00 sec)
mysql> show columns from searchindex; ERROR 1016 (HY000): Can't open file: 'searchindex.MYI' (errno: 145)
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
Any help is appreciated.
Shannon
____________________________________________________________________________________ TV dinner still cooling? Check out "Tonight's Picks" on Yahoo! TV. http://tv.yahoo.com/
On Tue, 2007-03-20 at 07:09 -0700, Shannon Adams wrote:
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
You need 'repair table', not just 'repair':
mysql> repair table wiki_it.searchindex;
-- brion vibber (brion @ wikimedia.org)
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
mediawiki-l@lists.wikimedia.org