List:General Discussion« Previous MessageNext Message »
From:Max Bube Date:April 21 2010 8:47pm
Subject:Re: Fw: BIN LOG Error when use Begin Trans in Replication.
View as plain text  
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