Best Bin log - type in MYSQL

--0-83498063-1272961977=:98528
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Hi, I am using win-server and xp for my master, slave setup. when i d=
o the beginTrans with bin-log =3D STATEMENT it is causing error. If i defin=
ed 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?=0ACan I ha=
ve your explanations? Thank you VIKRAM =0A
--0-83498063-1272961977=:98528--

Re: Best Bin log - type in MYSQL

Vikram,

> 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.

http://dev.mysql.com/doc/refman/5.1/en/replication-options-b inary-log.html#option_mysqld_log-bin

http://dev.mysql.com/doc/refman/5.1/en/binary-log-formats.ht ml


Ewen

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Best Bin log - type in MYSQL

--0-69809177-1272968500=:90980
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Sir, I am Sorry, My request is related to "binlog_format" variabl=
e. =0AThank you =0A________________________________=0AFrom: ewen =
fortune =0ATo: Vikram A =0ACc=
: MY SQL Mailing list =0ASent: Tue, 4 May, 2010 3:31=
:44 PM=0ASubject: Re: Best Bin log - type in MYSQL Vikram, > I am=
using win-server and xp for my master, slave setup. when i do the beginTra=
ns with bin-log =3D STATEMENT it is causing error. If i defined this with a=
ny one of the following, its working quite fine. MIXED, ROW.=0A>=0A> Which =
is the best one in the above two? Or how it differs?=0A> Can I have your ex=
planations? I think you are mixing up your log-bin and binlog_format v=
ariables.=0AThe first of which turns on binary logging and optionally takes=
a=0Afilename as an argument, the second controls the binary log format=0Aw=
hich can be STATEMENT, ROW or MIXED. http://dev.mysql.com/doc/refman/5=
..1/en/replication-options-binary-log.html#option_mysqld_log -bin http:/=
/dev.mysql.com/doc/refman/5.1/en/binary-log-formats.html=0A= 0A=0AEwen =
-- =0AMySQL General Mailing List=0AFor list archives: http://lists.mysql.co=
m/mysql=0ATo unsubscribe: http://lists.mysql.com/mysql?unsub=3Dvikkiatbi=
pl@yahoo.in
--0-69809177-1272968500=:90980--