>Description:
To make myself clear, I am talking about the binary update log file.
When specifing a fixed filename in my.cnf and running the flush-logs command
(via mysqladmin) MySQL does not close the file and open the new file when
run by a logrotate script. This does work correctly if no log f
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 l
s within the SET column without affecting the
existing contents?
I've tried a number of ways with no success!!
For example
UPDATE users SET user_flags = CONCAT(user_flags,'pass_renew') WHERE user_id
= 1
Any help or pointers would be greatly apprecia