On Thu, 8 Jul 2010, bruce bruce wrote: > I have this in /etc/my.cnf: > > [mysqld] > datadir=/var/lib/mysql > socket=/var/lib/mysql/mysql.sock > user=mysql > old_passwords=1 > log-error=/var/log/mysqld.log > > [mysqld_safe] > log-error=/var/log/mysqld.log > pid-file=/var/run/mysqld/mysqld.pid > log=/var/log/mysql_query.log > > But it doesn't log anything to /var/log/mysql_query.log
Move the "log" line to [mysqld] and restart MySQL. Personally, I'd create the log file in /tmp/ so there are no permissions issues. Be aware that using the query log may expose confidential information if you have other users and they have read access to the file. -- Thanks in advance, ------------------------------------------------------------------------- Steve Edwards [email protected] Voice: +1-760-468-3867 PST Newline Fax: +1-760-731-3000 -- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
