Plesk control Panel does not work. Unknown table engine 'InnoDB'.

Refers to:

  • Plesk 11.0 for Linux
  • Plesk 11.5 for Windows
  • Plesk 11.5 for Linux
  • Plesk 12.0 for Linux
  • MG:38c65afc716eb13600ef7ee9e59b5c92
  • MT:4b019da149d89480d0bea0fb4dcba89d

Created:

2016-11-16 12:46:19 UTC

Modified:

2017-02-13 06:12:48 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Plesk control Panel does not work. Unknown table engine 'InnoDB'.

Symptoms

Plesk Control Panel displays the following error:

ERROR: PleskMainDBException: MySQL query failed: Unknown table engine 'InnoDB' (db.php:102)
Search for related Knowledge Base articles

Cause

Incorrect MySQL configuration.

Option 'tmpdir' configured incorrectly, or does not exist:

root@server:/# cat /etc/mysql/my.cnf | grep tmpdir
tmpdir = /var/lib/mysql/for-tmp

root@server:~# ls /var/lib/mysql/for-tmp
ls: cannot access /var/lib/mysql/for-tmp: No such file or directory

Resolution

Fix "tmpdir" configuration, change it to correct path, or create required folder:

  1. Create new folder

    root@server:~# mkdir /var/lib/mysql/for-tmp
  2. Change owner to mysql:

    root@server:~# chown mysql:mysql /var/lib/mysql/for-tmp
  3. Restart MySQL service:

    root@server:~# /etc/init.d/mysql restart

    Stopping MySQL database server: mysqld.
    Starting MySQL database server: mysqld . ..
    Checking for corrupt, not cleanly closed and upgrade needing tables..
Have more questions? Submit a request
Please sign in to leave a comment.