Bug #7853 mysqlbinlog does not accept input from stdin
Submitted: 12 Jan 2005 23:45 Modified: 11 Feb 2005 9:47
Reporter: Stewart Smith Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:5.0 bk OS:Linux (Linux)
Assigned to: Mats Kindahl CPU Architecture:Any

[12 Jan 2005 23:45] Stewart Smith
Description:
mysqlbinlog cannot read from stdin.

This would be useful to fix as then you could zcat/bzcat old binlogs to view them.

How to repeat:
$ /usr/local/mysql5-port/bin/mysqlbinlog - < kennedy-bin.000001
/*!40019 SET @@session.max_insert_delayed_threads=0*/;

mysqlbinlog will now just sit there waiting for input.

Suggested fix:
There is the following comment in client/mysqlbinlog.cc (about line 1119)
" // reading from stdin; TODO: check that it works"
It doesn't.
[11 Feb 2005 9:47] Mats Kindahl
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

Fixed in 5.0.3

ChangeSet 1.1816 05/02/04 14:29:54 mats@mysql.com
  Bug#7853 (mysqlbinlog does not accept input from stdin)
    The utility 'mysqlbinlog' now accepts input from stdin. It can 
    now be used to read the output from, e.g., 'zcat' or other utility.