Search code examples
mysqlinnodbmyisamalter-table

Executing `ALTER TABLE my_table ENGINE InnoDB` on a MyISAM table has no effects. Why?

I want to change a table from MyISAM to InnoDB. I executed

ALTER TABLE database_name.table_name ENGINE = InnoDB;

inside of the mysql shell in the terminal. There were no error reports. But

SHOW CREATE TABLE database_name.table_name;

shows me, that the table is still in MyISAM. What do I miss?

Solution

  • Is InnoDB enabled on your server? Run SHOW ENGINES; query to check.