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.