From owner-freebsd-questions@FreeBSD.ORG  Thu May  1 18:09:33 2008
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 3C41A1065671
	for <freebsd-questions@freebsd.org>;
	Thu,  1 May 2008 18:09:33 +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 1AFEC8FC1E
	for <freebsd-questions@freebsd.org>;
	Thu,  1 May 2008 18:09: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 99296654FB;
	Thu,  1 May 2008 13:09:32 -0500 (CDT)
Date: Thu, 01 May 2008 13:09:32 -0500
From: Paul Schmehl <pauls@utdallas.edu>
To: John <vaughajj@jmu.edu>, freebsd-questions@freebsd.org
Message-ID: <7E01AC8E821E45790B514F2E@utd65257.utdallas.edu>
In-Reply-To: <200805011745.GER48602@jmu.edu>
References: <200805011745.GER48602@jmu.edu>
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: jjvaughan@gmail.com
Subject: Re: Recovering mysql data - mysqlbinlog
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 01 May 2008 18:09:33 -0000

--On Thursday, May 01, 2008 13:45:32 -0400 John <vaughajj@jmu.edu> wrote:

> Can someone direct me to where the MySQL transaction logs are stored?  I am
> running FreeBSD 6.1 with MySql 5.0.41 which I installed from ports, no extra
> config.  From what I've read online, unless you disable them (which I
> couldn't find in the makefile) the logs should be being created.  Doing a
> find / --name "bin." Didn't turn up anything.

/var/db/mysql/hostname-bin.number
/var/db/mysql/hostname-bin.index
/var/db/mysql/hostname.err

And if you've enabled query logging (stores passwords in plain text!)
/var/db/mysql/query.log

-- 
Paul Schmehl (pauls@utdallas.edu)
Senior Information Security Analyst
The University of Texas at Dallas
http://www.utdallas.edu/ir/security/