Date: Thu, 01 May 2008 15:24:33 -0500 From: Paul Schmehl <pauls@utdallas.edu> To: Mel <fbsd.questions@rachie.is-a-geek.net>, freebsd-questions@freebsd.org Cc: John <vaughajj@jmu.edu> Subject: Re: Recovering mysql data - mysqlbinlog Message-ID: <B7797CB8B91FC30D58FEBAC9@utd65257.utdallas.edu> In-Reply-To: <200805012152.06354.fbsd.questions@rachie.is-a-geek.net> References: <200805011913.DSZ93243@jmu.edu> <200805012152.06354.fbsd.questions@rachie.is-a-geek.net>
next in thread | previous in thread | raw e-mail | index | archive | help
--On Thursday, May 01, 2008 21:52:05 +0200 Mel <fbsd.questions@rachie.is-a-geek.net> wrote: > On Thursday 01 May 2008 21:13:41 John wrote: >> Thank you Mel and Paul for the suggestions. From what I understand the >> general query log is more for debugging and the binary log is for point in >> time recovery and replication. I'll be adding a my.cnf file (using the >> my-large.cnf as a skeleton) soon. I'm glad the issue was caught earlier on >> and now I'm the wiser thanks to you guys. I wonder why the default is no. >> I can't think of anyone who wouldn't find the binary logging beneficial. > > I can think of a reason for FreeBSD. The binary logs are never deleted and > upon every server restart a new one is created. If you're like me, developing > on a laptop with a webenvironment including 'Mysql server', shutting down > your laptop daily, you quickly find yourself having full /var partition. > That can be alleviated by adding the logs to newsyslog.conf and gzipping and rotating them regularly. If you don't restart mysql much, something like this would work: /var/db/mysql/[hostname]-bin.* mysql:mysql 660 7 * $W6D0 JBG /var/db/mysql/[FQHN].pid If you're restarting it daily, something like this should work: /var/db/mysql/[hostname]-bin.* mysql:mysql 660 25 * $D0 JBG /var/db/mysql/[FQHN].pid Adjust the counts and the rotation schedule to your liking and, of course, use your own hostname and fully qualified hostname. -- Paul Schmehl (pauls@utdallas.edu) Senior Information Security Analyst The University of Texas at Dallas http://www.utdallas.edu/ir/security/
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?B7797CB8B91FC30D58FEBAC9>