# I put everything in one block and added sharedscripts, so that mysql gets 
# flush-logs'd only once.
# Else the binary logs would automatically increase by n times every day.
/var/log/mysql.log /var/log/mysql/mysql.log /var/log/mysql.err /var/log/mysql/mysql.err {
	daily
	rotate 7
	missingok
	create 600 mysql mysql
	compress
	sharedscripts
	postrotate
		export HOME=/etc/mysql/my.cnf
		MYADMIN="/usr/bin/mysqladmin --defaults-extra-file=/etc/mysql/debian.cnf"
		if [ -n "`$MYADMIN ping 2>/dev/null`" ]; then
		  $MYADMIN flush-logs
		fi
		errlogs=`ls /var/log/mysql.err* /var/log/mysql/mysql.err* 2>/dev/null`
		if [ -n "$errlogs" ]; then 
		  chown 0.0 $errlogs
		fi
	endscript
}
