Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
Can't change binlog location
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Networking & Security
View previous topic :: View next topic  
Author Message
dE_logics
Advocate
Advocate


Joined: 02 Jan 2009
Posts: 2253
Location: $TERM

PostPosted: Mon Nov 09, 2015 5:33 am    Post subject: Can't change binlog location Reply with quote

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
View user's profile Send private message
Syl20
Guru
Guru


Joined: 04 Aug 2005
Posts: 564
Location: France

PostPosted: Mon Nov 09, 2015 10:34 am    Post subject: Reply with quote

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
View user's profile Send private message
dE_logics
Advocate
Advocate


Joined: 02 Jan 2009
Posts: 2253
Location: $TERM

PostPosted: Fri Nov 13, 2015 2:46 pm    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Networking & Security All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum