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]
