> I am using win-server and xp for my master, slave setup. when i do the beginTrans
> with bin-log = STATEMENT it is causing error. If i defined this with any one of the
> following, its working quite fine. MIXED, ROW.
> Which is the best one in the above two? Or how it differs?
> Can I have your explanations?
I think you are mixing up your log-bin and binlog_format variables.
The first of which turns on binary logging and optionally takes a
filename as an argument, the second controls the binary log format
which can be STATEMENT, ROW or MIXED.