So recently I upgraded to XAMPP for OS X 5.6.30
PHP Version 5.6.30
this version doesnot seem to support InnoDB.
7399
Infact I really didn’t care about it unless php mysql didnt start up .
So I changed the following in my.cnf file
skip-innodb
default-storage-engine=MyISAM
now when I try to run localhost/appname
I got the error
CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1286 Unknown storage engine 'InnoDB'
my database configuration remains unchanged as below
'db'=>array(
'connectionString' => 'mysql:host=localhost;dbname=boatdb',
'emulatePrepare' => true,
'username' => 'root',
'password' => '123',
'charset' => 'utf8',
),
please help!!