Avatar of overcolor
overcolor
 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?
MySQL ServerMac OS XColdFusion Language

Avatar of undefined
Last Comment
overcolor

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Kevin Cross

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
overcolor

ASKER
After a restart it worked worked perfect...Thank you
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23