Bug #43402 mysqlbinlog ignores data added using "insert into database.table values(...)
Submitted: 5 Mar 2009 8:31 Modified: 5 Mar 2009 13:18
Reporter: Kevin Stock Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Replication Severity:S2 (Serious)
Version:5.0.45 OS:Any
Assigned to: CPU Architecture:Any
Tags: mysqlbinlog

[5 Mar 2009 8:31] Kevin Stock
Description:
Scenario: I add data to a table without an explicit "use" command as follows

$ mysql
mysql> insert into mydb.mytable values (1, 1500);
mysql> \q

When I run mysqlbinlog --database=mydb, the above data is not included in the output.

How to repeat:
See description.
[5 Mar 2009 11:03] Sveta Smirnova
Thank you for the report.

This looks like duplicate of bug #43296. Please provide your configuration file to be sure.
[5 Mar 2009 11:15] Kevin Stock
Configuration file as requested (please see comments)

Attachment: my.cnf (application/octet-stream, text), 310 bytes.

[5 Mar 2009 11:21] Kevin Stock
I have attached the my.cnf file.

Please note that the logging option is not in the file; at present I am just testing MySQL, so I specify it on the command line when starting the server:

$ mysqld_safe --log-bin=claudius &

Looking at bug 43296, this may well be related although I do not use the other logging options mentioned in that bug (binlog_format and binlog_ignore_db).*
[5 Mar 2009 12:00] Sveta Smirnova
Thank you for the feedback.

I can not repeat described behavior with current development sources. Please indicate accurate version of MySQL package you are using (filename).
[5 Mar 2009 12:47] Kevin Stock
According to the mysql_config file, its 5.0.45
[5 Mar 2009 13:01] Sveta Smirnova
Thank you for the feedback.

I a sorry: I read initial description incorrectly.

You said: 'When I run mysqlbinlog --database=mydb, the above data is not included in the output.". This icorrect behavior: you have to have USE mydb; in the binary log to get output. See http://dev.mysql.com/doc/refman/5.0/en/mysqlbinlog.html#option_mysqlbinlog_database for details.
[5 Mar 2009 13:18] Kevin Stock
OK; however this behaviour seriously limits the usefulness of mysqlbinlog for incremental backups. Can this be turned into an enhancement request to extract all changes affecting the specified database?
[10 Mar 2009 15:33] Sveta Smirnova
Thank you for the feedback.

Regarding to incremental backup please wait when version 6.0 with new feature online backup is released: http://dev.mysql.com/doc/refman/6.0/en/backup-database-restore.html