1286
MySQLerrorddlhigh confidence
Unknown storage engine
Production Risk
Medium — table creation fails; application may not function correctly.
What this means
A CREATE TABLE or ALTER TABLE statement specified a storage engine that is not installed or not compiled into this MySQL build.
Why it happens
- 1Referencing a third-party engine (e.g. TokuDB, RocksDB) that is not loaded
- 2Typo in the ENGINE= clause
- 3Restoring a dump created on a different MySQL variant
How to reproduce
trigger — this will error
trigger — this will error
CREATE TABLE t (id INT) ENGINE=TokuDB;
expected output
ERROR 1286 (42000): Unknown storage engine 'TokuDB'
Fix 1
List available engines
List available engines
SHOW ENGINES;
Why this works
Shows all installed and supported storage engines.
Fix 2
Use InnoDB instead
Use InnoDB instead
CREATE TABLE t (id INT) ENGINE=InnoDB;
Why this works
InnoDB is the default and universally available engine.
What not to do
✕
Version notes
Sources
Official documentation ↗
MySQL 8.0 — 1286 ER_UNKNOWN_STORAGE_ENGINE
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev