Michael
Luc Foisy wrote:
I hade it misconfigured (wrong param name prior to MySQL 4.0)again it writes to $HOSTNAME.err
Doc Quote http://dev.mysql.com/doc/mysql/en/Error_log.html
Beginning with MySQL 4.0.10, you can specify where mysqld stores the
error log file with the option --log-error[=file_name]. If no file_name
value is given, mysqld uses the name `'hostname'.err' and writes the file
in the data directory. (Prior to MySQL 4.0.10, the Windows error log name
is `mysql.err'.) If you execute FLUSH LOGS the error log will be renamed
with a suffix of -old and mysqld creates a new empty log file. >
In older MySQL versions on Unix, error log handling was done by mysqld_safe which redirected the error file to 'hostname'.err. You could change this filename by specifying a --err-log=filename option to mysqld_safe. End Doc Quote
I changed it to what it should be according to the documentation and
[mysqld_safe] --err-log=/usr/data/mysql/mysql.err
I am restaring MySQL with: /etc/rc.d/init.d/mysql stop /etc/rc.d/init.d/mysql start
mysql Ver 11.18 Distrib 3.23.58, for pc-linux (i686) RedHat 9.0
What I am seeing with ps -axw 14683 pts/0 S 0:00 /bin/sh /usr/bin/safe_mysqld --datadir=/usr/data/mysql --pid-file=/usr/data/mysql/mysql.pid 14712 pts/0 S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/usr/data/mysql --user=mysql --pid-file=/usr/data/mysql/mysql.pid
-----Original Message-----
From: Luc Foisy Sent: Monday, April 12, 2004 9:12 AM
To: Paul DuBois; MYSQL-List (E-mail)
Subject: RE: mysql error file
I changed mysql_safe to mysqld_safe and it is still sending the error output to $HOSTNAME.err
-----Original Message----- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 11:17 AM To: Luc Foisy; MYSQL-List (E-mail) Subject: Re: mysql error file
At 10:10 -0400 4/7/04, Luc Foisy wrote:
I have the following in my /etc/my.cnf
[mysqld] datadir=/usr/data/mysql pid-file=/usr/data/mysql/mysql.pid socket=/usr/data/mysql/mysql.sock user=mysql
[mysql_safe] log-error=/usr/data/mysql/mysql.err
[client] socket=/usr/data/mysql/mysql.sock
I tried originally to put the log-error= in the [mysqld] section and it errored out, believe I read somewhere then that it should be in the [mysql_safe] section
My log file is still writing to $HOSTNAME.err
Is me /etc/my.cnf file wrong in some way?
You might want to use [mysqld_safe] rather than [mysql_safe].
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]