MySQL Bugs: #43402: mysqlbinlog ignores data added using "insert into database.table values(...)

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

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.

Thank you for the report.

This looks like duplicate of bug #43296. Please provide your configuration file to be sure.

Configuration file as requested (please see comments)

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

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).*

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).

According to the mysql_config file, its 5.0.45

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.

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?

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