Recovering mysql data - mysqlbinlog

[Paul Schmehl]

--On Thursday, May 01, 2008 13:45:32 -0400 John <vaughajj at 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 at utdallas.edu)
Senior Information Security Analyst
The University of Texas at Dallas
http://www.utdallas.edu/ir/security/