Article ID: 116922, created on Aug 26, 2013, last review on Feb 17, 2015

  • Applies to:
  • Plesk Automation 11.1
  • Plesk Automation 11.5
  • Plesk 12.0 for Linux
  • Plesk 11.0 for Linux
  • Plesk 11.5 for Linux
  • Plesk 12.0 for Windows


  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

Search Words

Upgrade Plesk 12

ERROR: PleskMainDBException: MySQL query failed: Unknown table engine 'InnoDB' (db.php:102)

ERROR: PleskMainDBException: MySQL query (select param, val from misc) failed: Unknown table engine 'InnoDB' (db.php:102)

ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory (Abstract.php:144)

ERROR: Zend_Db_Statement_Exception SQLSTATE[HY000]: General error: 1030 Got error -1 from storage engine

ERROR: Zend_Db_Statement_Exception: SQLSTATE[42000]: Syntax error or access violation: 1286 Unknown storage engine 'InnoDB' (Pdo.php:234)


I cannot add subscription

panel is does not work

mysql daemon not starting

ERROR 1286 (42000) at line 1: Unknown table engine 'InnoDB'

Unknown table engine 'InnoDB'

Plesk loading blank page

Unable to connect to database

mysql no such file


panel does not work

Plesk panel login page blank

a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c 01bc4c8cf5b7f01f815a7ada004154a2 29d1e90fd304f01e6420fbe60f66f838 0a53c5a9ca65a74d37ef5c5eaeb55d7f e0aff7830fa22f92062ee4db78133079 aea4cd7bfd353ad7a1341a257ad4724a caea8340e2d186a540518d08602aa065 ed7be2b984f9c27de1d2dc349dc19c6d 85a92ca67f2200d36506862eaa6ed6b8 a766cea0c28e23e978fa78ef81918ab8 2a5151f57629129e26ff206d171fbb5f e335d9adf7edffca6a8af8039031a4c7 33a70544d00d562bbc5b17762c4ed2b3 c1ecc6010feff26cb42d1d14a7881dd6

Email subscription for changes to this article
Save as PDF