What about issueing first drop index, then add index? Should do
the job. Or repair table. What does check table or myisamchk say?
shawn reed schrieb am Montag, 30. Juli 2001, 07:44:15:
> hi all,
> i apologize for the utterly newbie-ish question, but i've yet to find an
> answer to it after having spent quite some time searching mysql's web site
> (especially since half the links i click on now seem to be giving me 404
> errors...)
> how does one reindex a table containing fulltext indexes? the reason i
> ask this is... a table that i had set up w/ fulltext indexes suddenly
> returns no rows when i perform a search on it... and it used to work just
> fine. everything i have read seems to be telling me to reindex the
> table.. and quite frankly that's the only thing i can think of doing since
> nothing else has changed that should be causing the searches to no longer
> function properly.
> any help would be appreciated.
> ~shawn
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Herzlich
Werner Stuerenburg
_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
