Unknown table engine 'InnoDB'

Sometimes on initial mysql setup, you will find that you can log into the db, use db. But when you select * from table, you get the following error message:
Table 'db.tablename' doesn't exist

This is most likely because the data you are importing was intended for a non-transactional configured database.

To reconfigure the database as a non-transactional one: execute C:/.../MySQL Server X.Y/bin/MySQLInstanceConfig.exe

After this is done, you still need to alter the my.ini configuration file to tell mysql to use the innodb engine. If not you will likely see this error message:
Unknown table engine 'InnoDB'

To which the solution is to make sure you have the following line in your my.ini file:
default-storage-engine=INNODB

No comments: