Hi Max Bube,
The following are the variables related to the binlog.
mysql>show variables
varibale_name : Value
.
.
.
binlog_cache_size : 32768
binlog_direct_non_transactional_updates : OFF
binlog_format : STATEMENT
.
.
.
By default I found the statement based[it is better than row based?] format for bin log.
I left it as such. I hope it is enough.
As you said, in the my.ini file which part i suppose to add this binlog-format =
statement ?
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
>
