[ZODB-Dev] Error from MySQL when attempting to run zodbconvert

[Shane Hathaway]

On 01/31/2011 06:30 PM, Chris Withers wrote:
> Hi Shane,
>
> I got the following error when trying to run zodbconvert against a
> clustered MySQL environment running RHCS:
>
>     File
> "/var/buildout-eggs/MySQL_python-1.2.3-py2.6-linux-i686.egg/MySQLdb/connections.py",
> line 36, in defaulterrorhandler
>       raise errorclass, errorvalue
> _mysql_exceptions.OperationalError: (1598, "Binary logging not possible.
> Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for
> binlog mode 'STATEMENT'")

That's why you have to use row-based replication instead of 
statement-based replication.

Shane