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:
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

[11 Mar 2008 21:20] Peter Gulutzan
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

How to repeat:
SELECT @@binlogdir;
[11 Mar 2008 23:01] MySQL Verification Team
Thank you for the bug report.
[28 Nov 2009 17:09] Meir Guttman
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:
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!