Plesk DB error : Unknown table engine 'InnoDB'

[Webroy]

Hi:

After a clean install of Centos 6 64bit and Plesk 11 i get this error:

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

my.cnf:

[mysqld]
local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

====================================

I tried bootstrapper.sh repair and restorecon -R /var/lib/mysql/

No results,

anyone a idea?

Best Regards

 

[IgorG]

There are may be different reasons of this issue. Have you found and additional error logs in mysqld log?

 

[abdi]

Do you get the error when restarting Plesk or MySQL, otherwise you could also try the following:

rm -f /var/lib/mysql/ib_logfile*
/etc/init.d/mysql restart
/etc/init.d/psa restart

If that fails, then try this:

cp /etc/my.cnf /etc/my.cnf.bk
vim /etc/my.cnf

and add the following

[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
old_passwords=1
set-variable = innodb_buffer_pool_size=2M
set-variable = innodb_additional_mem_pool_size=500K
set-variable = innodb_log_buffer_size=500K
set-variable = innodb_thread_concurrency=2
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
skip-bdb
set-variable = innodb_buffer_pool_size=2M
set-variable = innodb_additional_mem_pool_size=500K
set-variable = innodb_log_buffer_size=500K
set-variable = innodb_thread_concurrency=2

and the finely, restart MySQL

/etc/init.d/mysql restart

 

[Nikolay.]

and add the following

1) NEVER EVER use "old_passwords=1" with Plesk 11! Otherwise it will break login capabilities with time.
2) "set-variable" option is archaic. Instead of "set-variable = innodb_buffer_pool_size=2M" you can just write "innodb_buffer_pool_size=2M".
3) Default value for innodb_buffer_pool_size is 8M and it is considered to be low for most installations, yet you advise to set it to even lower value! I'd advise against setting specific values for innodb configuration parameters unless you know what you do. Otherwise there's a high chance to cripple InnoDB performance.