"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]