Hello.
For changing one table, the recommended way is
ALTER TABLE foo TYPE=MYISAM;
There is no built-in way to change several tables at once. I regulary
have the need to apply the same command to some tables. If you use
some UNIX shell, you can do something like this:
mysql your_db -t -e "S
At 18:58 + 12/18/02, John P wrote:
I have about 300 database tables that are mostly ISAM and some MyISAM
format. I would like to move them all into MyISAM - what's the
easiest/quickest way? I am running 3.23.54.
I was thinking of doing mysqldump, then using a search/replace in the file
CREATE
I just did this sort of thing in the innodb direction. What I did was a
mysql dump, global search and replace of MyISAM to InnoDB in the dump ddl
file, dropped and recreated the database, then restored.
-
Chris Kulish
Systems Engineer
ING Advisors Network
Ph. (515) 698-7583
Fx. (515) 698-358
