List:General Discussion« Previous MessageNext Message »
From:Vikram A Date:May 4 2010 10:21am
Subject:Re: Best Bin log - type in MYSQL
View as plain text  
Sir,

I am Sorry,

My request is related to "binlog_format" variable.


Thank you


________________________________
From: ewen fortune <ewen.fortune@stripped>
To: Vikram A <vikkiatbipl@stripped>
Cc: MY SQL Mailing list <mysql@stripped>
Sent: Tue, 4 May, 2010 3:31:44 PM
Subject: Re: Best Bin log - type in MYSQL

Vikram,

> I am using win-server and xp for my master, slave setup. when i do the beginTrans
with bin-log = STATEMENT it is causing error. If i defined this with any one of the
following, its working quite fine. MIXED, ROW.
>
> Which is the best one in the above two? Or how it differs?
> Can I have your explanations?

I think you are mixing up your log-bin and binlog_format variables.
The first of which turns on binary logging and optionally takes a
filename as an argument, the second controls the binary log format
which can be STATEMENT, ROW or MIXED.

http://dev.mysql.com/doc/refman/5.1/en/replication-options-binary-log.html#option_mysqld_log-bin

http://dev.mysql.com/doc/refman/5.1/en/binary-log-formats.html


Ewen

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1


Thread
Best Bin log - type in MYSQLVikram A4 May
  • Re: Best Bin log - type in MYSQLewen fortune4 May
    • Re: Best Bin log - type in MYSQLVikram A4 May