Why do I get "Binary Log Impossible". on my MySQL server?

Question

When I started my MySQL server today and try to make some changes using Toad for Mysql , I get this message:

MySQL database error

Binary log is not possible. Message: The READ-COMMITTED transaction level in InnoDB is not safe for the APPLICATION binlog mode

I have no idea what that means. I am running Mysql on VirtualBox with Ubuntu 11.x.

Has anyone encountered this problem before?

Answer 1

ERROR 1598 (HY000): . : READ-COMMITTED InnoDB Binlog :

:

• binlog ROW MIXED,

  mysql> SET GLOBAL binlog_format = 'ROW';
  

• MySQL , , , option --log-bin mysqld MySQL.