Change from InnoDB to MYISAM

Alan Tse · #1 (**permalink**) 10-24-05, 02:59

I have installed MySQL 5 and would like to change the database type from InnoDB to MYISAM, how do I do that ?

popskie · #2 (**permalink**) 10-24-05, 04:07

if u want to change ur table type to myisam then u can use
alter table tablename engine = myisam;

Alan Tse · #3 (**permalink**) 10-24-05, 19:13

Can I set the database engine as MyISAM when installing MySQL 5.0 ?

popskie · #4 (**permalink**) 10-24-05, 22:56

U should change ur configuration file my.cnf in ur mysql intallation root directory.

popskie · #5 (**permalink**) 10-25-05, 01:27

just add dis line to ur configuration file. its either a my.cfn or a my.ini filename. Under mysqld entry. This filename located in ur mysql subdirectory. i hop u dis can help u.
default-table-type=myisam

Internet Services

Web Development

Digital Marketing

Consumer Tech