MySQL Workbench EER Diagramm - how to change storage engine?
mysql-workbench
Solution
It's not very obvious but when editing a table there is a blue arrow on the right. If you click this you get more options where you can alter the storage engine.
Problem
I use MySQL Workbench 5.2.38. and I have made an EER Diagram. But on export I got surprised with InnoDB as defined storage engine. Altering the table afterwards is not an option because I do not have an InnoDB engine. ERROR 1286 (42000): Unknown storage engine 'InnoDB' So, I have changed the Default Engine via Edit-> Preferences -> Model: MySQL to MyISAM but on export there is still InnoDB in use?! I am completely unable to find the option to change the storage engine in table editor. Can someone help me how I can change the storage engine for my tables in MySQL Workbench ERR?