Product:
Search Type:

After autoupdate Mysql fails to start: "Cannot initialize InnoDB".

Article ID: 301 
Last Review: Apr,14 2008
APPLIES TO:
  • Plesk 7.1.x Reloaded
  • Plesk 7.5.x Reloaded

RESOLUTION

Usualy "Cannot initialize InnoDB" shows up because 'innodb_data_file_path' is not set. If you do not wish to use transactional InnoDB tables, add the line:

skip-innodb

into the [mysqld] section in /etc/my.cnf.


If you want to use InnoDB tables, add to the [mysqld] section:

innodb_data_file_path = ibdata1:10M:autoextend

To get good performance, InnoDB startup options should be adjysted accordingly to your hardware, see for more information: http://dev.mysql.com/doc/refman/5.1/en/innodb-configuration.html

Restart MySQL after the my.cnf file modification.

Please provide feedback on this article

Did this article help you solve your issue?
Yes
No
Partially
I do not know yet
 
Strongly Agree   Strongly Disagree
  9 8 7 6 5 4 3 2 1
The article is easy to understand
The article is accurate
Additional Comments:
*Please provide us with your email address in case we need to contact you.
*Please type the code you can see.
* - required fields