Re: Help please: SELECT in binlog?

2007-04-19 Thread David Precious
Fionn Behrens wrote: On Do, 2007-04-19 at 13:57 -0400, Jay Pipes wrote: You can have both, AFAIK. The general query log keeps all queries, including SELECTs. Binlog only has data-modifying queries. Thanks very much for your answer. Maybe the fact that binlogs apparently are quite different

Re: Help please: SELECT in binlog?

2007-04-19 Thread Fionn Behrens
On Do, 2007-04-19 at 13:57 -0400, Jay Pipes wrote: > You can have both, AFAIK. The general query log keeps all queries, > including SELECTs. Binlog only has data-modifying queries. Thanks very much for your answer. Maybe the fact that binlogs apparently are quite different from normal text lo

Re: Help please: SELECT in binlog?

2007-04-19 Thread Jay Pipes
Fionn Behrens wrote: We recently switched to mysql5 and while we were at it we also changed our logs from text to bin as suggested by the migration script we had (probably created by debian people). Now I unfortunately had to reconstruct what had happened during a faulty run of our application a