BUG: Update Log does not re-open file when filename specified

2001-10-29 Thread Nick Brandon
>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

Backups and flush logs

2001-10-18 Thread Nick Brandon
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

UPDATEing values in SET columns

2001-07-19 Thread Nick Brandon
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