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

Question

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 ?

0

Report

06 Dec 2020 at 03:45 PM

onefive

myisam

sql

1 answer

OK

Tim · Answer 1

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.

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

myisam

sql

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

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

Fix error: mysqli_select_db / query expects 2 arguments, 1 given

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

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

Insert or update current date in DATETIME format - SQL

Difference between Fetch_assoc, Fetch_array, Fetch_row - MySQL