On Fri, 10 Jan 2003, Michael T. Babcock wrote:
> >if test -n "`ps acx|grep mysqld`"; then
> >/usr/bin/mysqladmin flush-logs
> >fi
> >
> >
>
> You're probably running it as root with the password loading from the
> /root/.my.cnf or something. Try adding the -uro
Jiann-Ming Su wrote:
if test -n "`ps acx|grep mysqld`"; then
/usr/bin/mysqladmin flush-logs
fi
You're probably running it as root with the password loading from the
/root/.my.cnf or something. Try adding the -uroot -p command-line
options, or a [mysqladmin]
I'm using mysql that was distributed by mysql.com. I seem to be having
a problem with logrotate. When I run logrotate manually on mysql only,
the logs seem to rotate fine. But, when it runs in the cron job, it
creates the new log, but mysql continues to log to the old log.
My mysql logrotate