Mysql problem. Help.

Discussion in 'MySQL' started by komrad, Aug 12, 2008.

0
  1. #1
    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?
     
    komrad, Aug 12, 2008 IP