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! > > > 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? > > > 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? 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