log-bin not logging UPDATEs
Posted by:
Johnny Boy
Date: February 14, 2008 08:12AM
I'm having trouble getting updates to get logged in the bin log using python's MySQLdb 1.2.2 and Mysql client+server 5.0.51a running on FreeBSD 6.2
When I do this in python:
d = MySQLdb.connect("host", "login", "password")
c = d.cursor()
c.execute("UPDATE table SET something=123")
d.commit()
The table is updated and I can see the change,
but only "COMMIT" is in the bin log, nothing about the actual UPDATE line.
Then if I do the exact same query from mysql command line (or PHP's mysqli), it get's logged just fine.
I've read the documentation and it states that it should log everything that changes the table, and it does change the table. I'm not clueless of what's wrong.
This also breaks my replication since the slave doesn't get this update from the bin log.
Any hints?
Subject
Written By
Posted
log-bin not logging UPDATEs
February 14, 2008 08:12AM
February 14, 2008 02:08PM
February 15, 2008 02:11AM
February 15, 2008 02:26AM
February 15, 2008 07:54AM
February 18, 2008 03:12AM
February 15, 2008 02:27AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.