> We are looking to convert all ISAM tables to the new type MYISAM.... > > Has anyone else converted all tables in all their databases in one fell > swoop to > a new type? using the alter table command. > > Thanks for any gotchas, hints or suggestions.
A somewhat unconventional method which works very well (it should be noted that we did this when the data had to be moved to a new host anyway): Dump the data using mysqldump, then use sed or your favorite editor to change instances of "ISAM" to "MyISAM", then re-import the data once again. It's actually quite fast, and adds the advantage that you can off-load the temporary copy (i.e. the dump files) to another disk - which was an important issue in our particular case. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq --------------------------------------------------------------------- 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
