MySQL Bugs: #35231: Variable for binlog directory

Bug #35231	Variable for binlog directory
Submitted:	11 Mar 2008 21:20	Modified:	11 Mar 2008 23:01
Reporter:	Peter Gulutzan	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Backup	Severity:	S4 (Feature request)
Version:	6.0.5-alpha-debug	OS:	Linux (SUSE 10 \| 32-bit)
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
There should be a variable for 'binlog directory'.

It should be the same as datadir ordinarily.
But users could change it, if they wanted to
ensure that data files and log files are kept
separate.

How to repeat:
SELECT @@binlogdir;

Thank you for the bug report.

One way to redirect the bin-log to another directory is to add a full path to the "log-bin=" parameter in the INI file.
However, the real issue IMHO is to redirect it to another machine!
In Windows/File-Sharing for Microsoft Networks there is a big impediment, see my post on the MySQL "Backup" forum:
http://forums.mysql.com/read.php?28,292455,292455#msg-292455
I don't see a solution except to make MySQL stream the binlog data through a TCP pipe to a receiving process on the remote machine. This process will then save it to a local file.
Other solutions are most welcome!
Meir