title: Executing `ALTER TABLE my_table ENGINE InnoDB` on a MyISAM table has no effects. Why?
body: <p>I want to change a table from MyISAM to InnoDB. I executed</p>
  
  <pre><code>ALTER TABLE database_name.table_name ENGINE = InnoDB;
  </code></pre>
  
  <p>inside of the mysql shell in the terminal. There were no error reports. But</p>
  
  <pre><code>SHOW CREATE TABLE database_name.table_name;
  </code></pre>
  
  <p>shows me, that the table is still in MyISAM. What do I miss?</p>