mysql-bin.index not found (Errcode: 13) when trying to start with log_bin
I'm trying to set up replication, and I've run into a snag. When I enable the following line in my.cnf
log_bin = /big/0/mysql/log/mysql/mysql-bin.log
I get the following error when I try to start mysqld:
/usr/sbin/mysqld: File '/big/0/mysql/log/mysql/mysql-bin.index' not found (Errcode: 13)
Now, when I've searched for this error, it seems to be a permissions problem. I can get it to work with the default path,
log_bin = /var/log/mysql/mysql-bin.log
What I don't understand is what is wrong with the permissions. Both directories look (to me) to have the same permissions. Here is the file listing for the path which works:
cboyce@thor:~$ sudo ls -la /var/log/mysql/
total 15708
drwxr-s--- 2 mysql mysql 4096 2011-06-02 03:54 .
drwxr-xr-x 16 root root 4096 2011-06-02 03:54 ..
-rw-rw---- 1 mysql mysql 0 2011-06-02 03:54 error.log
-rw-rw---- 1 mysql adm 3308 2011-06-02 02:01 error.log-old
-rw-rw---- 1 mysql mysql 125 2011-06-02 01:53 mysql-bin.000001
-rw-rw---- 1 mysql mysql 125 2011-06-02 01:58 mysql-bin.000002
-rw-rw---- 1 mysql mysql 3082162 2011-06-02 03:54 mysql-bin.000003
-rw-rw---- 1 mysql mysql 12967727 2011-06-02 13:05 mysql-bin.000004
-rw-rw---- 1 mysql mysql 128 2011-06-02 03:54 mysql-bin.index
And the path that doesn't work:
cboyce@thor:~$ sudo ls -la /big/0/mysql/log/mysql/
total 8
drwxr-s--- 2 mysql mysql 4096 2011-06-02 01:58 .
drwxr-xr-x 3 mysql mysql 4096 2011-06-02 01:58 ..
I'm not seeing any difference in the permissions, so I'm not sure if that is the problem and I'm not seeing it, or there's something else going on. Any thoughts?
Subject
Views
Written By
Posted
mysql-bin.index not found (Errcode: 13) when trying to start with log_bin
39948
June 02, 2011 02:13PM
10873
June 03, 2011 07:00PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.