Where to find mySQL logs?

max2000

Verified User
Joined
Nov 7, 2004
Messages
144
Location
Europe
Thank you Jeff,

But this files doens't exist on my servers.


server:/# ls /var/log/myslqd.log
ls: /var/log/myslqd.log: No such file or directory


Any other idea?
 

Chrysalis

Verified User
Joined
Aug 25, 2004
Messages
1,584
Location
uk
touch /var/log/mysqld.log
chown mysql /var/log/mysqld/log
then restart mysqld

if the file doesnt exist mysql wont create it for you.
 

duncan

Verified User
Joined
Jan 19, 2005
Messages
94
Location
Halifax, NS, Canada
To pull up this old thread....

MySQL crashed on my box today. I went looking for the error logs, but I can't seem to find any.

Using the advice above, I should create a log then? Sounds strange to me....

Any thoughts?
 
Top