search

jyr / MNPP

Mac + Nginx + Percona + PHP a high performance web server in a one-click installer
http://getmnpp.org
314 stars 49 forks source link

MNPP supprot mysql Innodb? #43

Closed nathan-zhu closed 11 years ago

nathan-zhu commented 12 years ago

I need use Innodb type on mysql, but get error from mnpp, "PDOException: SQLSTATE[42000]: Syntax error or access violation: 1286 Unknown table engine 'InnoDB':"

check the mysql status for innodb:

+---------------+-------+------+ | Variable_name | Value | +---------------+-------+---+ | have_innodb | NO | ----------------+-------+----+

How to use it here? Please help.

jyr commented 12 years ago

Hi Nathan,

By defaults InnoDB is enabled. try with 'show engines' from mysql console and 'show engine innodb status'