i've tried simply re-creating the index as you suggested ... no luck.
here's a brief summary of my situation: i developed an application on one
server, after it was developed and ready to go live we started to move it
to another server. after moving it i noticed my search function wasn't
working... i fiddled around with the database quite a bit, with no
luck. then i realized that the search function wasn't working on the
development server either, and it had been working fine all along. that's
what makes no sense to me at all. :(
output from myisamchk on the development server is as follows:
***
Checking MyISAM file: inventory
Data records: 2 Deleted blocks: 5
myisamchk: warning: 1 clients is using or hasn't closed the table properly
- check file-size
- check key delete-chain
- check record delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check data record references index: 3
- check data record references index: 4
- check data record references index: 5
- check data record references index: 6
- check data record references index: 7
- check data record references index: 8
- check data record references index: 9
- check data record references index: 10
- check data record references index: 11
- check data record references index: 12
- check record links
MyISAM-table 'inventory' is usable but should be fixed
***
i'm not real familiar with myisamchk so i'm not sure exactly what i need
to do to repair this table, since it said it should be fixed.
i also still have no clue why this search suddenly stopped working. =/
frustrated,
~shawn
On Mon, 30 Jul 2001, Werner Stuerenburg wrote:
> 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
>
>
>
>
---------------------------------------------------------------------
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