changing engine type to MyISAM unknown engine

Question

i need to change table type from innoDB to myISAM

ALTER TABLE table_name ENGINE = MyISAM;

Tried this but results in error:

Error 1286: Unknown storage engine 'MEMORY' SQL Statement: ALTER TABLE tab_name ENGINE = MyISAM

I was able to do the same a few months ago but unable to do now.

Can anyone help?

thanks

Answer 1

Do you have myisam enabled in your install? Check with

show engines;