Re: how to get text SQL log

2009-02-24 Thread Cui Shijun
thank you for your reply :) I've roughly read some source codes about MYSQL_BIN_LOG & Log_Event. It seems that the way which mysql writes binlog in is per Log_Event. In that case, records are stored in sequence, just like plain text logs does. So, even if I can write pure SQLs into an another plai

Re: how to get text SQL log

2009-02-24 Thread Baron Schwartz
Hi, On Mon, Feb 23, 2009 at 11:10 PM, Cui Shijun wrote: > hi, >  I've been using mysql-5.1.22 in my project, which processes a lot of > read operations but little write operations. I got the idea from some > of my coworkers that binlog has a chance to be corrputed so that > mysqlbinlog can't proc