3 messages in com.mysql.lists.mysqlChange Location of Error Logging (Was...
FromSent OnAttachments
Basil Hussain15 Nov 2000 07:23 
Basil Hussain15 Nov 2000 09:26 
Kent Hoover15 Nov 2000 10:42 
Subject:Change Location of Error Logging (Was: Changing Location of PID File)
From:Basil Hussain (basi@specialreserve.net)
Date:11/15/2000 09:26:48 AM
List:com.mysql.lists.mysql

I seem to have get everything apart from the PID file to re-locate.

I did actually manage to get the PID file to a different location. The reason why I was stumped on it before was because in the results from doing SHOW VARIABLES the name of the variable for the location of MySQL's PID file is listed as 'pid_file', but mysqld expects it as 'pid-file' in your my.cnf file!!

Anyway, I have hit upon another trouble. Is it possible to get the MySQL error log to write to a different location other than /var/lib/mysql/? I can't seem to find a variable to set for that.

Regards,