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
0give a positive ratinggive a negative ratingshow more
onefiveonefive
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
0give a positive ratinggive a negative ratingshow more
TimTim
Share on FacebookShare on TwitterShare on LinkedInSend email
Follow us on Facebook
2022 AnswerTabsTermsContact us