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 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?
No, no selects. Only commands that change data are replicated, AFAIK.
2) If they are not there by default, can I configure mysqld to store
SELECTs in a binlog?
Not that I know of.
3) If not, is the old text log all I can go back to?
You can have both, AFAIK. The general query log keeps all queries,
including SELECTs. Binlog only has data-modifying queries.
Cheers,
jay
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
