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/