Hi! On Nov 28, Gordan Bobic wrote: > On Wednesday 28 Nov 2001 10:37, Sergei Golubchik wrote: > > > 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 > > Ah, it was the -h!
No - it is now :-) > > > > 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. > > But the new server will still be able to read the old format tables? > Otherwise it couldn't rebuild them, right? Yes, sure. File format is the same. > > > > 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. > > Will I have to do this manually, of will ALTER TABLE do all that for me? ALTER TABLE is enough. 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