List:General Discussion« Previous MessageNext Message »
From:Fionn Behrens Date:April 19 2007 5:44pm
Subject: Help please: SELECT in binlog?
View as plain text  
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 and I could not get any SELECT statement from the
log!? The usual search engine run didnt bring up anything useful,

so my questions are:

1) Are the selects somwhere in the binlogs and I just have not found
   the right voodoo to make the come out?

2) If they are not there by default, can I configure mysqld to store
   SELECTs in a binlog?

3) If not, is the old text log all I can go back to?


thanks for reading,
			Fionn


Thread
Help please: SELECT in binlog?Fionn Behrens19 Apr
  • Re: Help please: SELECT in binlog?Jay Pipes19 Apr
    • Re: Help please: SELECT in binlog?Fionn Behrens19 Apr
      • Re: Help please: SELECT in binlog?David Precious19 Apr