MySQL Forums
Forum List  »  Replication

mysql-bin.index not found (Errcode: 13) when trying to start with log_bin
Posted by: Chris Boyce
Date: June 02, 2011 02:13PM

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?

Options: ReplyQuote


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


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.