7

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

MySQL Database Error

Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'

I have no idea what this means. I'm running Mysql on VirtualBox with Ubuntu 11.x.

Has anyone run into this problem before?

Steven
  • 19,224
  • 47
  • 152
  • 257

1 Answers1

11

According to ERROR 1598 (HY000): Binary Logging not Possible. Message: Transaction Level READ-COMMITTED in InnoDB is not Safe for Binlog Mode STATEMENT:

There are several solutions for the issue:

  • You need to change the binlog mode to either ROW or MIXED in order to run the load of the data into the database

    mysql> SET GLOBAL binlog_format = 'ROW';

  • If you are not planning to use your MySQL server for the replication consider turning the binary logging off by removing the option --log-bin from the command options for the mysqld utility starting the MySQL server.

Vikram
  • 8,235
  • 33
  • 47
  • I did that last bit. I had turned it ON because I was trying to debug some issues. – Steven Mar 12 '12 at 10:55
  • setting the binlog_format did not resolve my problem. any other advice as to what it could be? – Seaux Apr 05 '13 at 20:42
  • actually, the `SET GLOBAL` just didn't work. i had to set 'binlog_format' in /etc/my.cnf and restart mysql. – Seaux Apr 05 '13 at 20:49