I am Sorry,
My request is related to "binlog_format" variable.
From: ewen fortune <ewen.fortune@stripped>
To: Vikram A <vikkiatbipl@stripped>
Cc: MY SQL Mailing list <mysql@stripped>
Sent: Tue, 4 May, 2010 3:31:44 PM
Subject: Re: Best Bin log - type in MYSQL
> 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.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1