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 >
