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 ?
This notification is related to the table storage engine configuration. You can check the engines with:
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.
|How to add side by side rows in excel pivot table ?|
|Free email accounts with large or unlimited storage capacity|
|Does LTE mean 4G ? Difference between LTE and 4G|
|What is definition of ROA, ROI, ROE, ROS, EBITDA in finance ?|
|Check if value exists in column more than once or twice - Excel|
|Man Month calculation - how many man days or man hours ?|
|What is good PPI of smartphone display ? How to calculate it ?|