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
give a positive ratinggive a negative rating
06 Dec 2020 at 03:45 PM
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.

0
give a positive ratinggive a negative rating
09 Dec 2020 at 10:47 AM
Tim
Share on FacebookShare on TwitterShare on LinkedInSend email
x
x
Follow us on Facebook
2022 AnswerTabsTermsContact us