Menu
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?
571
Access phpMyAdmin and select your database. Then click on SQL, place the following query and click on Go: ALTER TABLE my_table ENGINE = InnoDB; If the query is executed properly, the database engine of the table will be changed to InnoDB.
From the MySQL Workbench 5.2 window, select Database -> Synchronize model which will allow you to synchronize the model (EER diagram) with the database (you need to create a saved connection) for it.
InnoDB : The default storage engine in MySQL 8.0. InnoDB is a transaction-safe (ACID compliant) storage engine for MySQL that has commit, rollback, and crash-recovery capabilities to protect user data.
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.
95
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
