MySQL error: Unknown table engine 'InnoDB' - how to fix ? | |||||||||||
When I try to run the SQL request related to certain table in database I get an error notification: Unknown table engine 'InnoDB' Why does the notification appear and how can I fix it ? | |||||||||||
| |||||||||||
Hi, This notification is related to the table storage engine configuration. You can check the engines with: SHOW ENGINES; You can also see the engine of each table in database: SHOW TABLE STATUS FROM database_name; It looks that because of the settings the server see the InnoDB engine assigned to some tables, but InnoDB engine is probably disabled. You have to check the configuration in my.ini. | |||||||||||
| |||||||||||
| |||||||||||
![]() ![]() ![]() ![]() | |||||||||||
2022 AnswerTabs | Terms | Contact us |