Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 01 May 2008 13:09:32 -0500
From:      Paul Schmehl <pauls@utdallas.edu>
To:        John <vaughajj@jmu.edu>, freebsd-questions@freebsd.org
Cc:        jjvaughan@gmail.com
Subject:   Re: Recovering mysql data - mysqlbinlog
Message-ID:  <7E01AC8E821E45790B514F2E@utd65257.utdallas.edu>
In-Reply-To: <200805011745.GER48602@jmu.edu>
References:  <200805011745.GER48602@jmu.edu>

next in thread | previous in thread | raw e-mail | index | archive | help
--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/




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?7E01AC8E821E45790B514F2E>