List:General Discussion« Previous MessageNext Message »
From:Vikram A Date:April 22 2010 5:05am
Subject:Re: Fw: BIN LOG Error when use Begin Trans in Replication.
View as plain text  
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 <maxbube@stripped>

To: Vikram A <vikkiatbipl@stripped>
Cc: MY SQL Mailing list <mysql@stripped>
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 <vikkiatbipl@stripped>

Hi Hao Ding,
>
>
>I attached in my request mail it self. Please find the attachment. 
>Thank you
>
>
>
>
________________________________
From: hao ding <fire9dingh@stripped>
>To: Vikram A <vikkiatbipl@stripped>
>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 <vikkiatbipl@stripped> 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=1
>>
>
>
>
>
>>--
>>MySQL General Mailing List
>>For list archives: http://lists.mysql.com/mysql
>>To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>



Thread
Fw: BIN LOG Error when use Begin Trans in Replication.Vikram A21 Apr
  • Re: Fw: BIN LOG Error when use Begin Trans in Replication.Max Bube22 Apr
Re: Fw: BIN LOG Error when use Begin Trans in Replication.Vikram A22 Apr
Re: Fw: BIN LOG Error when use Begin Trans in Replication.Vikram A22 Apr