Hi
I've been trying to answer this question for a while with no success :) I
know someone here has the answer!
As part of my backup, I have the following line in the my.cnf
# Activate Update Log
log-bin=update-bin.log
I then run a script by logrotated every night, the config file is:
# This logname is set in mysql.server.sh that ends up in
/etc/rc.d/init.d/mysql
#
# If the root user has a password you have to create a
# /root/.my.cnf configuration file with the following
# content:
#
# [mysqladmin]
# password = <secret>
# user= root
#
# where "<secret>" is the password.
#
# ATTENTION: This /root/.my.cnf should be readable ONLY
# for root !
/home/mysql/data/update-bin.log {
create 600 mysql mysql
notifempty
daily
rotate 7
missingok
compress
postrotate
# just if mysqld is really running
if test -n "`ps acx|grep mysqld`"; then
/usr/local/mysql/bin/mysqladmin flush-logs
fi
endscript
}
I am running Linux with MySQL 3.23.38. Currently while running tests and
running the script above the output of the data directory is:
-rw-rw---- 1 mysql mysql 34 Oct 15 21:40 update-bin.index
-rw------- 1 mysql mysql 0 Oct 15 21:42 update-bin.log
-rw------- 1 mysql mysql 238928 Oct 15 21:42 update-bin.log.1.gz
During this time I have another PHP script in the background adding 200,000
records (using independent INSERT's with NO locks). I trying to find out why
the server does not continue to log to update-bin.log after the logrotate
script has run?
Any ideas would be greatly appreciated.
Thanks
Nick
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
