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

[Chris Withers]

On 31/01/2011 16:30, Chris Withers wrote:
> 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'")

I fixed this by setting binlog-format to MIXED rather than STATEMENT in 
my.cnf. There don't appear to be any downsides to this, so maybe this 
should go in the docs somewhere?

cheers,

Chris

-- 
Simplistix - Content Management, Batch Processing & Python Consulting
            - http://www.simplistix.co.uk