| View previous topic :: View next topic |
| Author |
Message |
dE_logics
Advocate
Joined: 02 Jan 2009
Posts: 2289
Location: $TERM
|
 Posted: Mon Nov 09, 2015 5:33 am Post subject: Can't change binlog location |
 |
|
I'm running mariadb 10.0.21. On trying to change the binlog location --
| Code: | | log_bin = /tmp/binlogs/mixed_bin |
| Code: | | mysqld: File '/tmp/binlogs/mixed_bin.index' not found (Errcode: 2 "No such file or directory") |
Permissions as mysql:mysql on /tmp/binlogs
_________________
My blog |
|
| Back to top |
|
 |
Syl20
l33t
Joined: 04 Aug 2005
Posts: 621
Location: France
|
| Posted: Mon Nov 09, 2015 10:34 am Post subject: |
|
|
I don't think putting binlogs on /tmp is a good choice, even if your system doesn't wipe /tmp on boot. The directory has the sticky bit set by default.
However, /tmp/binlogs belongs to mysql:mysql, but is mysql able to write on the directory ? Did you try to create an empty /tmp/binlogs/mixed_bin.index file, writable by mysql, just to see if that resolve the problem ? |
|
| Back to top |
|
|
dE_logics
Advocate
Joined: 02 Jan 2009
Posts: 2289
Location: $TERM
|
| Posted: Fri Nov 13, 2015 2:46 pm Post subject: |
|
|
| CneGroumF wrote: | I don't think putting binlogs on /tmp is a good choice, even if your system doesn't wipe /tmp on boot. The directory has the sticky bit set by default.
However, /tmp/binlogs belongs to mysql:mysql, but is mysql able to write on the directory ? Did you try to create an empty /tmp/binlogs/mixed_bin.index file, writable by mysql, just to see if that resolve the problem ? |
It's just an experiment.
I logged in as user mysql to ensure it could write to it and I tired making the empty binlog index file too.
_________________
My blog |
|
| Back to top |
|
|
|
Networking & Security
