Re: log information in MySQL
Jon Miller [EMAIL PROTECTED] wrote: I need a way to log every message that MySQL generates. I have the following in the /etc/my.cnf file: [mysqld] port=3309 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock log-bin=/var/log/mysql.log bind-address=192.168.0.15 log=/var/log/mysqlquery.log [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid Also in /etc/syslog.conf I have an entry: # Log Mysql messages mysqld.*/var/log/mysqld.log Not sure if this will work. Any suggesstions? And what is the problem? Log files are not created or they are empty or what? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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]
log information in MySQL
I need a way to log every message that MySQL generates. I have the following in the /etc/my.cnf file: [mysqld] port=3309 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock log-bin=/var/log/mysql.log bind-address=192.168.0.15 log=/var/log/mysqlquery.log [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid Also in /etc/syslog.conf I have an entry: # Log Mysql messages mysqld.*/var/log/mysqld.log Not sure if this will work. Any suggesstions? Yet when I go to look for any info I do not see anything. Jon L. Miller, MCNE, CNS, ASE Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]