Howdy,
I tried to run logmysql.server start with grant tables.
[root@tusd-exch01 zcs]# Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
060330 12:58:50 mysqld ended
So, I thought I'd take a look at the mysqld.log
060330 12:58:49 mysqld started
060330 12:58:50 [ERROR] /opt/zimbra/logger/mysql/bin/mysqld: unknown variable 'defaults-file=/opt/zimbra/conf/my.logger.cnf'
060330 12:58:50 mysqld ended
So I decided to look at the my.logger file.
Code:
[mysqld]
basedir = /opt/zimbra/logger/mysql
datadir = /opt/zimbra/logger/db/data
socket = /opt/zimbra/logger/db/mysql.sock
pid-file = /opt/zimbra/logger/db/mysql.pid
bind-address = localhost
port = 7307
skip-external-locking
log-slow-queries = /opt/zimbra/log/logger_myslow.log
long-query-time = 1
log-long-format
log-queries-not-using-indexes
log-bin
thread_cache = 10
max_connections = 10
# We do a lot of writes, query cache turns out to be not useful.
query_cache_type = 0
[mysqld_safe]
err-log = /opt/zimbra/log/logger_mysqld.log
Does this log look correct?
thx