Just edit the logrotate config for the mysql logs and change the create line.
From: "Anthony Wlodarski" <anth...@dating2p0.com> To: "NYPHP Talk" <talk@lists.nyphp.org> Sent: Tuesday, September 7, 2010 2:43:51 PM Subject: Re: [nyphp-talk] MySQL slow query log/general mysql log MySQL does rotate the slow query log at least on my systems it is automated. I did a quick look at the MySQL man pages just to verify if it does behave this way but could not confirm. This could present a problem when MySQL goes to rotate it off. If it uses an internal "cp -p" then permissions and the such will just be copied to the backup logs. However I don't know if the original file is truncated or recreated. If it is recreated then MySQL will only recreate it with the default 640 permissions. If it is just truncated then you are in the clear but I am willing to be on the aforementioned.
_______________________________________________ New York PHP Users Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/Show-Participation
