I added the line to the configuration file and removed "--log-error=" line from startup line but it still creates the /usr/local/mysql/var/yoda2.err as well as /var/log/mysql/error.log

I am assuming it is reading from my.cnf as I get the following when I run "mysqladmin variables"
log_error                       | /var/log/mysql/error.log

I also checked for possible duplicate my.cnf files but there is only one.

Is there another way to check to be sure it's reading the configuration file?

At 12:40 PM Sunday, 6/5/2005, Gleb Paharenko wrote -=>
Unfortunately I could give suggestion only about your second question.
Is it possible that /var/log/mysql/error.log created by mysqld_safe
(you're specifying it with --log-error command line option) and
/usr/local/mysql/var/yuda2.err is created by mysqld process if it
founds problems before applying location of error log to it's internal
variable? Specify

  log-error       = /var/log/mysql/error.log

in your configuration file, and check that MySQL Server actually reads this file.

Ed Kasky wrote:
> Hello there -
>
> I have a couple of questions regarding a new install of MySql 4.1.12 on
> RH 7.2.  Being new to this list, I sure do hope this hasn't been covered
> before.  I have scrubbed Google and searched the archives for this list
> but can't find an explanation or a solution to 2 issues:
>
> 1.  I get the following error when starting the daemon:
>
> 050605  7:08:51 [Warning] Found an entry in the 'db' table with empty
> database name; Skipped
>
> Is this something that should be fixed and if so, how does one go about it?
>
> 2.  I have set the error log to /var/log/mysql/error.log in the init
> script:
>
> LOG_ERROR="/var/log/mysql/error.log"
> $bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file
> --log-error=$LOG_ERROR
>
> However, I am still getting 2 error logs:
>
> What I am assuming is the default "/usr/local/mysql/var/yoda2.err"
> and the one specified - "/var/log/mysql/error.log"
>
> Is this expected behavior?  Is there another place aside from
> /etc/my.cnf that I might look?
>
> Thanks in advance for any tips and/or suggestions.
>
> Ed
>
> . . . . . . . . . . . . . . . . . .
> Randomly Generated Quote (116 of 975):
> "It had long since come to my attention that people of
>  accomplishment rarely sat back and let things happen
>  to them. They went out and happened to things."  - Elinor Smith
>
>


--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

. . . . . . . . . . . . . . . . . .
Randomly Generated Quote (203 of 975):
"To climb steep hills requires slow pace at first."
     - William Shakespeare


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to