Contents
How do I fix InnoDB unknown storage engine?
How to fix the error ‘Unknown table engine ‘innodb”
- Enable InnoDB in the configuration file. If InnoDB support is disabled in the configuration file, here is how to fix it.
- Recreate the InnoDB log files.
- Edit the configuration settings.
- Setup MySQL server with InnoDB support.
Is InnoDB a storage engine?
InnoDB is a general-purpose storage engine that balances high reliability and high performance. In MySQL 5.6, InnoDB is the default MySQL storage engine. Unless you have configured a different default storage engine, issuing a CREATE TABLE statement without an ENGINE clause creates an InnoDB table.
What does unknown storage engine InnoDB mean in Linux?
The message was “Unknown storage engine ‘InnoDB'”. After about 2 weeks of searching the configuration fault without results and by a miracle, today, I saw that some of the linux components cannot write in /tmp.
Why does phpMyAdmin say unknown table engine InnoDB?
Suppose you try to create a new table using the command (“CREATE TABLE t1 (a INT, b CHAR (20), PRIMARY KEY (a)) ENGINE=InnoDB;”). The table creation fails giving the error – ERROR 1286 (42000) at line 1: Unknown table engine ‘innodb’. Table creation or listing using PhpMyAdmin may also not work.
Why do I get unknown table engine in MySQL?
If the InnoDB engine is disabled in the MySQL database server configuration, it will give error ‘Unknown table engine ‘innodb” whenever you try to create a table with InnoDB support. It can happen if the MySQL server is not compiled with InnoDB support or if the InnoDB support is disabled via configuration settings.
How can I erase the InnoDB part of the query?
You problem lays in the ENGINE=InnoDB part of the query. You can eventually try to erase this, if you don’t care about the storage engine. Another solution (the hard one if you don’t know about database servers) is to change the storage engine in configuration. If you are able/authorized to do it, configure your database engine using InnoDB.