I am not certain, but I am going to guess you are using a INNODB table, and you haven’t done a commit. I believe MySQLdb enable transactions automatically.
Call conn.commit() before calling close.
From the FAQ: Starting with 1.2.0, MySQLdb disables autocommit by default