Hi! On Nov 28, Gordan Bobic wrote: > 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... :-(
Just added: % ./ft_dump Use: ./ft_dump [-dscvh] <table_name> <index_no> -d dump index (incl. data offsets and word weights) -s report global stats -c calculate per-word stats (counts and global weights) -v be verbose -h this text > > > 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? Yes. OPTIMIZE or REPAIR TABLE is too weak, as these commands preserve MYI header. ALTER TABLE will recreate the table from scratch. > > Still, I'd like to make file formats fully compatible Unfortunately it's hardly possible. Sorting order is changed, so index has to be rebuilt. Regards, Sergei -- MySQL Development Team __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ --------------------------------------------------------------------- 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