Hi Ryan,
Did you look in you "hostname.err" file for the error at the end of
the file? Are you running the mysql daemon as root? Could it be the
user you are running mysqld as does not have permission to write to
/root? The ".err" file by default is in the directory with your other
logs (on my system /usr/local/var/picard.icarz.com.err ). Either tail
or cat the file and look at the error on the end.
Best of luck
Ken
----- Original Message -----
From: "Ryan Shrout" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 30, 2001 2:50 PM
Subject: Enabling Logging of Slow Queries
> I have tried to enable slow query logging for a couple days now,
with no
> success.
>
> I have tried adding the line to the my.cnf file as well as stoppign
the
> service then starting it with the command line version. Both ways,
the
> server refuses to restart. I have checked the syntax over and over
and I
> think I have it correct!
>
> [mysqld]
> log-slow-queries=/root/slow-queries.log
>
> and
>
> /etc/usr/bin/safe_mysqld --log-slow-queries=/root/slow-queries.log
>
> Either way, the server will not start. I take the line out and it
works
> again. What am I doing wrong?
>
> Ryan Shrout
> Owner - Amdmb.com
> http://www.amdmb.com/
> [EMAIL PROTECTED]
>
>
> --------------------------------------------------------------------
-
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
