On Tuesday 27 Nov 2001 23:28, Sergei Golubchik wrote: > > Another question - is there a way to acquire a list of words in the FTS > > index? Someting like > > > > SELECT Word, > > count(*) AS Frequency > > FROM FTSIndex > > GROUP BY Word > > ORDER BY FREQUENCY ASC > > LIMIT 100; > > There's myisam/ft_dump utility that can dump fulltext index ot of MYI file.
Is there any documentation on how to use it and what the parameters mean? The help it gives isn't all that descriptive... :-( > > BTW, will the file formats be compatible? Or will it require a dump + > > restore of the database, when going from 4.0.0 to 4.0.1? > > For now - there's one bit changed - and one has to rebuild the table. > The easiest way is 'ALTER TABLE ... TYPE=MYISAM', though dump+restore > will work too, of course. I'm not sure I follow what you mean. All my tables are already of type MyISAM (that's all I compiled MySQL with!) Are you saying that I should install the new binaries "on top", restart the server, and just do the ALTER TABLE as above on each table? > Still, I'd like to make file formats fully compatible - so, > you'd better take a look at the ChangeLog section of the > manual included in the 4.0.1 distribution. Will do. When I actually get my hands on the 4.0.1 tar ball. Regards. Gordan --------------------------------------------------------------------- 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