From owner-freebsd-questions@FreeBSD.ORG Thu May 1 20:24:34 2008 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 3E7031065671 for ; Thu, 1 May 2008 20:24:34 +0000 (UTC) (envelope-from pauls@utdallas.edu) Received: from smtp3.utdallas.edu (smtp3.utdallas.edu [129.110.10.49]) by mx1.freebsd.org (Postfix) with ESMTP id 1BB758FC0A for ; Thu, 1 May 2008 20:24:33 +0000 (UTC) (envelope-from pauls@utdallas.edu) Received: from utd65257.utdallas.edu (utd65257.utdallas.edu [129.110.3.28]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by smtp3.utdallas.edu (Postfix) with ESMTP id 6388A654FB; Thu, 1 May 2008 15:24:33 -0500 (CDT) Date: Thu, 01 May 2008 15:24:33 -0500 From: Paul Schmehl To: Mel , freebsd-questions@freebsd.org Message-ID: 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> X-Mailer: Mulberry/4.0.8 (Linux/x86) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Cc: John Subject: Re: Recovering mysql data - mysqlbinlog X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 01 May 2008 20:24:34 -0000 --On Thursday, May 01, 2008 21:52:05 +0200 Mel 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/