"Carsten H. Pedersen" wrote: > > 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.
We did it in one fell swoop, had no problems. I would make a backup copy, just in case though. Denis volunteermatch.org --------------------------------------------------------------------- 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