Link to home
Start Free TrialLog in
Avatar of D F
D FFlag for United States of America

asked on

Error using MySQL 5.5 with 4.4 database on MAC

I'm using Coldfusion 10, Mysql 5.5 on a MAC and when I imported my old data base from a 4.4 Mysql I get this error:

impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.

can someone please walk me step by step on how to solve this problem?
ASKER CERTIFIED SOLUTION
Avatar of Kevin Cross
Kevin Cross
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of D F

ASKER

After a restart it worked worked perfect...Thank you