Bug #18626 mysqlbinlog for windows does not accept wildcards in filenames

• Submitted: 29 Mar 2006 17:47
• Modified: 22 May 2006 15:23
• Reporter: [ name withheld ]
• Status: Won't fix
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0.19
• OS: Windows (Windows 2000 SP4)
• CPU Architecture: Any

[29 Mar 2006 17:47] [ name withheld ]

Description:
mysqlbinlog (on Windows) is unable to find input binary log files when using wildcards on the command line. 

A simple example:

D:\MySQL Datafiles>dir /b /-p ds1-bin.0*
ds1-bin.000001
ds1-bin.000002

D:\MySQL Datafiles>mysqlbinlog ds1-bin.0*
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
mysqlbinlog: File 'ds1-bin.0*' not found (Errcode: 22)
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;

Specifying the file name explicitly works fine:

D:\MySQL Datafiles>mysqlbinlog ds1-bin.000001
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
# at 4
#060329  9:09:15 server id 1  end_log_pos 98    Start: binlog v 4, server v 5.0.
19-nt-log created 060329  9:09:15 at startup
ROLLBACK;
# at 98
#060329  9:09:18 server id 1  end_log_pos 117   Stop
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;

Using the 8.3 DOS style filenames with wildcards did not work either.

How to repeat:
Attempt to run mysqlbinlog on windows using wildcards in the filename.

[22 May 2006 12:35] MySQL Verification Team

Thank you for the bug report. The use of wildcards depends of the shell
features and Windows lack some features you find on Unix.

[22 May 2006 15:23] [ name withheld ]

As shown in the first part of the example, the Windows command shell DOES contain the aforementioned wildcard features, mysqlbinlog does not however. The ability to process all binary log files without specifying each individually (or writing an external script or batch file) is pretty useful functionality

[27 Apr 2009 9:56] Pranab Sharma

Yes it will be a really useful feature. I also tried in a test database in Windows XP.