[ale] MySQL binlog on the slave

[Michael B. Trausch]

On Wed, 2008-05-14 at 14:47 -0400, Chris Fowler wrote:
> I had a new today to see what SQL statements were executed by some 
> software.  Since these are not logged I had the smart idea to look at 
> the slave server.  Where and how do I find these?  I thought that
> maybe the binlog files would show me all SQL executed on the slave but
> the only ones I could find was when I did the initial import many
> months ago.

It should have relay logs, they're what MySQL uses for replication
logging.  Check /var/run/mysqld on the slave server.  At least, that is
where it is on Debian/Ubuntu.  You can probably search the system for
files called mysqld-relay-bin.*.

	--- Mike

-- 
Michael B. Trausch                                   mike at trausch.us
home: 404-592-5746, 1                                 www.trausch.us
cell: 678-522-7934                       im: mike at trausch.us, jabber
Ubuntu Unofficial Backports Project:    http://backports.trausch.us/

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://mail.ale.org/pipermail/ale/attachments/20080514/233cf88a/attachment.bin