hi, I tried with ROW and MIXED tyoe it is working fine. When i go for statement based, it is causing the error.
mysql> SET GLOBAL binlog_format = 'STATEMENT'; mysql> SET GLOBAL binlog_format = 'ROW'; mysql> SET GLOBAL binlog_format = 'MIXED'; can you suggest Which is the best format? Thank you VIKRAM From: Max Bube <maxb...@gmail.com> To: Vikram A <vikkiatb...@yahoo.in> Cc: MY SQL Mailing list <mysql@lists.mysql.com> Sent: Thu, 22 April, 2010 2:17:29 AM Subject: Re: Fw: BIN LOG Error when use Begin Trans in Replication. Hi Vikram, Add binlog_format=row to your my.ini master's conf file 2010/4/21 Vikram A <vikkiatb...@yahoo.in> Hi Hao Ding, > > >I attached in my request mail it self. Please find the attachment. >Thank you > > > > ________________________________ From: hao ding <fire9di...@gmail.com> >To: Vikram A <vikkiatb...@yahoo.in> >Sent: > Wed, 21 April, 2010 7:25:05 PM >Subject: Re: BIN LOG Error when use Begin Trans in Replication. > >Vikram, >I don't find my.ini. > > >On > Wed, Apr 21, 2010 at 9:19 PM, Vikram A <vikkiatb...@yahoo.in> wrote: > >Hi, >> >>I have installed mysql 5.1.45 version on windows server 2003[standard >>edition] and windows xp. I am using WIN SERVER as MASTER and WIN XP as slave. >>And the default engine in both severs is INNODB. >> >>I am using visual basic for my front end. The replication system is running >>quite well. >> >>When i am using the rs.BeginTrans >>I am facing the following error when i am pointing my master, >> >>[MySQL][ODBC 5.1 Driver][mysqld-5.1.45-community-log]Binary logging not >>possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe >>for binlog mode 'STATEMENT' >> >>If i point my slave as server[I have done for checking beginTrans]; it is >>running quite well. >> >>Can I have help from any one. It will be useful to me. >> >>I am attaching the my.ini for your reference. >> >>Thank you >> >>Vikram A >> >> >> >> >>>>-- >>>>MySQL General Mailing List >>>>For list archives: http://lists.mysql.com/mysql >> >>To unsubscribe: http://lists.mysql.com/mysql?unsub=fire9di...@gmail.com >> > > > > >>-- >>MySQL General Mailing List >>For list archives: http://lists.mysql.com/mysql >>To unsubscribe: http://lists.mysql.com/mysql?unsub=maxb...@gmail.com >
