[Gllug] mysql binary logs

Sean Burlington sean at uncertainty.org.uk
Mon Jun 13 18:30:59 UTC 2005


On Monday 13 Jun 2005 6:01 pm, Alain Williams wrote:
> I am trying, unsucessfully, to do something that should be incredibly
> simple.
>
> I am trying to switch on binary logging in mysql. 

> The database itself works (queries/selects) -- I just can't get the logging
> to appear to do anything.
>

I was in a similar predicament some time ago, then I realised that the binlog 
only logs statements that change the database, and I was testing the binlog 
facility by running select statements.

Selects do not get logged, from your comments it appears you may be making the 
mistake that I made ...

I have:

[mysqld]
(port, socket, buffer size etc)
log-bin=/var/log/mysql/mysqlbinlog

-- 

Sean
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug




More information about the GLLUG mailing list