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.
|Best battery saving tips - How to save battery on Phone or Tablet|
|How to calculate inverse currency exchange rate ?|
|How to add side by side rows in excel pivot table ?|
|Remove or hide bottom navigation bar with buttons on Android|
|How to change QWERTZ keyboard to QWERTY in Windows 10 ?|
|How to see who is invited to a meeting - attendees in Outlook|
|Samsung Galaxy A & F better than M series ? What's the difference ?|