PDA

View Full Version : Problem: ALTER from ISM to MYI table types


TheFiringLine.com
Thu 12th Apr '01, 12:18pm
I've used the command:
ALTER TABLE [table name] TYPE = MYISAM;

Everything appears to run correctly, but the old files remain in the directory and the new ones are not created (no "myi" files).

Am I missing something?
Rich

Mitrofan
Tue 17th Apr '01, 10:24am
MYISAM types only supported in mysql 3.23 and newer
If you have mySQL 3.22 then it will not convert your tables with this command.

TheFiringLine.com
Tue 17th Apr '01, 1:05pm
Thanks.
This is for 3.23. I finally found the info in MySQL's rather cryptic and cluttered documentation.
Rich