From: bruce (bedouglasearthlink.net)
Date: Sat Dec 08 2007 - 19:44:53 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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:bedouglasearthlink.net]
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:mgaintyhotmail.com]
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" <bedouglasearthlink.net>
To: "'mysql list'" <mysqllists.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/mysql?unsub=mgaintyhotmail.com
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=bedouglasearthlink.net

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]