InnoDB Engine is absent in Database server

Refers to:

  • Plesk 12.5 for Linux
  • Plesk 11.0 for Linux
  • Plesk 11.5 for Windows
  • Plesk 11.5 for Linux
  • Plesk 12.0 for Windows
  • Plesk 12.0 for Linux
  • MG:d8490a7adb10047c36b2df85da1ba64f
  • MG:38c65afc716eb13600ef7ee9e59b5c92
  • MT:806310e84cd269b1bb54afbbea6412e8
  • MG:1d94c73557184d9295d141e060014f9f
  • MG:5180e2aea7fd7bffd6dca86fc94914b3
  • MT:30d44619d237aeea690aa1698636ec02
  • MT:4b019da149d89480d0bea0fb4dcba89d


2016-11-16 12:40:51 UTC


2017-02-21 09:56:04 UTC


Was this article helpful?

Have more questions?

Submit a request

InnoDB Engine is absent in Database server


  1. InnoDB is not listed among the available storage engines in the DB Webadmin/phpMyAdmin interface when creating a new table.

  2. An attempt to create a table with ENGINE=InnoDB fails with this error:

    ERROR 1286 (42000) at line 1: Unknown table engine 'innodb'
  3. An attempt to back up databases using the mysqldump utility fails:

    mysqldump: Got error: 1286: Unknown table engine 'InnoDB' when using LOCK TABLES Dumping : db1_table
  4. MySQL server fails to start with the following error in /var/log/mysqld.log :

    130826 10:37:08 [ERROR] Unknown/unsupported storage engine: InnoDB


The InnoDB engine is disabled in the MySQL database server configuration.


  1. Stop MySQL service:

    # /etc/init.d/mysql stop
  2. Make a backup copy of the MySQL data directory (default location is /var/lib/mysql ):

    # cp -a /var/lib/mysql /var/lib/mysql.orig
  3. Open the file /etc/my.cnf (or the file /etc/mysql/my.cnf on Debian/Ubuntu) for editing.

  4. Find the skip-innodb parameter and either remove it or comment the line by adding # at the beginning of the line:

  5. Insert the following parameters into the [mysqld] and [mysqld_safe] sections in /etc/my.cnf :

  6. Save the file and start MySQL:

    # /etc/init.d/mysql start
Have more questions? Submit a request
Please sign in to leave a comment.