I have experienced this issue before. When I got the error, I just put everything back in the data directory.
MySQL, somewhere in its code, expects the binlog index to be in the data directory, even when we configure it to be elsewhere. I think the regular binlogs can be stored elsewhere, but MySQL still expects the index file to be in the data directory. Try configuring the index file to be stored in the data directory, while configuring the binlogs to be stored in the logs directory as you wanted. log-bin = /var/log/mysql/mysql_bin.log log-bin-index = /var/lib/mysql/mysql_bin.index If it works, it would be great if you could file a bug for this. Include steps to reproduce this issue. -RG bruce wrote: > oh... > > btw, also made sure the permissions are set on the /var/log/msql dir, and > the underlying files, as well as that the owner/group are 'mysql'... > > thanks > > > > -----Original Message----- > From: bruce [mailto:[EMAIL PROTECTED] > Sent: Saturday, December 08, 2007 5:39 PM > To: 'mysql list' > Subject: RE: log-bin > > > > arrggg.. > > hi martin. > > nope, i tried to add the line to my my.cnf file. in fact, i also copied the > bin log files from the /var/lib/... to the /var/log/mysql dir > > i now have in the my.cnf file > > ---->>log-bin = /var/log/mysql/mysql_bin.log > ---->>log-bin-index = /var/log/mysql/mysql_bin.index > > > i have the following in the /var/log/mysql dir > ------------------- > mysql-bin.000001 mysql-bin.000003 mysql-bin.000005 mysql_bin.index > mysql-bin.000002 mysql-bin.000004 mysql-bin.000006 > ------------------- > i get the same err as before... > > > again, if i simply only have the "log-bin" in the my.cnf, allowing mysql to > write things to the "default" locations then everything starts as > expected... > > thanks > > > > -----Original Message----- > From: Martin Gainty [mailto:[EMAIL PROTECTED] > Sent: Saturday, December 08, 2007 1:49 PM > To: bruce > Subject: Re: log-bin > > > Bruce- > > when log-bin is enabled > log-bin = /var/log/mysql/mysql_bin.log > > specify log-bin-index > log-bin-index[=file_name] > > http://blog.robinz.info/archives/2006/04/13/fixedmysqld-file-mysql-binindex- > not-found-errcode-13/ > M- > ----- Original Message ----- > From: "bruce" <[EMAIL PROTECTED]> > To: "'mysql list'" <mysql@lists.mysql.com> > Sent: Saturday, December 08, 2007 3:44 PM > Subject: log-bin > > >> hi... >> >> i'm trying to run mysql on a fedora core 5, system to allow the log bin >> files to be created. >> >> i have the following my.cnf file: >> >> ----------------------------------- >> [mysqld] >> datadir=/var/lib/mysql >> socket=/var/lib/mysql/mysql.sock >> max_connections=3 >> #log-error = /var/log/mysql_err.log >> #set-variable = log=/var/log/mysql_query.log >> log-bin = /var/log/mysql/mysql_bin.log >> #set-variable = log-slow-queries=/var/log/mysql_slow.log >> # Default to using old password format for compatibility with mysql 3.x >> # clients (those using the mysqlclient10 compatibility package). >> old_passwords=1 >> >> [mysql.server] >> user=mysql >> #basedir=/var/lib >> basedir=/usr >> >> >> [mysqld_safe] >> err-log=/var/log/mysqld.log >> pid-file=/var/run/mysqld/mysqld.pid >> ------------------------------------------ >> >> when i run /etc/init.d/mysql start, it dies, and i get an error stating > that >> the mysql_bin.index isn't found: (the mysqld.log file) >> >> 071208 11:09:25 mysqld started >> /usr/libexec/mysqld: File '/var/log/mysql/mysql_bin.index' not found >> (Errcode: 13) >> 071208 11:09:25 [ERROR] Aborting >> >> if i comment out the log-bin line in the my.cnf file, mysql starts/runs, > but >> i don't get the log bin files. >> >> if i run mysqld-safe --log-bin, it apparently creates the log bin files... >> >> i can't find the error that i see above when i search the 'net... >> >> basically, i'm looking to be able to test using the log bin files for > backup >> purposes. >> >> any thought/ideas... >> >> thanks >> >> -tom >> >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >> >> > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
