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 ?

06 Dec 2020 at 03:45 PM

onefive

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.

09 Dec 2020 at 10:47 AM

Tim

MySQL error: Unknown table engine 'InnoDB' - how to fix ?

Error: Illegal parameter data types INT and row for operation '='

Is faster one big SQL query or multiple small SQL queries ?

Copy and update rows in the same table with autoincrement - SQL

Insert or update current date in DATETIME format - SQL

Fix SQL error Index for table 'user_db' is corrupted, try to repair it

Error: You can't specify target table for update in FROM clause

SQL query with SELECT COUNT() in SELECT - subquery example