Hi, Try to enable query log.
Thanks & Regards Dilipkumar [EMAIL PROTECTED]: > Hey there, I inherited a couple of servers that are in production but I > > noticed that there\'s not active logging for mysql on any of them. I > looked and they don\'t have an active my.cnf file any where on the > machines. One machine is running mysql 4.1.5 and the other is running > mysql 5.0.18 > > When I ran a ps -ef on the machines I saw this for both > /usr/local/mysql/bin/mysqld > ----defaults-extra-file=/usr/local/mysql/data/my.cnf so I went and I put > > a my.cnf right where it was looking for it. Stopped/Started the mysql > server and I\'m still not seeing any logging happening for the mysql > servers. Perhaps I\'m messing this up? I want them to log everything to > /var/log/mysqld.log and in the my.cnf I have the line: > > log = /var/log/mysqld.log > > Can anyone tell me where I\'m messing this up or what is wrong? > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]