<div>
Ok I have set it explicitly to &quot;ROW&quot; and perfrom some deletion on tables, I check what is captured in binlog but it still in statement based, <br />
<br />
<br />
<br />
SET TIMESTAMP=1234760963/*!*/;<wbr /><br />
BEGIN<br />
/*!*/;<br />
# at 847<br />
#090216 13:09:23 server id 1 &nbsp;end_log_pos 961 &nbsp; Query &nbsp; thread_id=6 &nbsp; &nbsp; exec_time=0 &nbsp; &nbsp; error_code=0<br />
SET TIMESTAMP=1234760963/*!*/;<wbr /><br />
delete from address where id &gt;450001 and id &lt;450116<br />
/*!*/;<br />
# at 961<br />
#090216 13:09:23 server id 1 &nbsp;end_log_pos 988 &nbsp; Xid = 40<br />
COMMIT/*!*/;<br />
DELIMITER ;<br />
# End of log file<br />
ROLLBACK /* added by mysqlbinlog */;<br />
/*!50003 SET COMPLETION_TYPE=@OLD_COMPL<wbr />ETION_TYPE<wbr />*/;<br />

</div>


Ok I have set it explicitly to "ROW" and perfrom some deletion on tables, I check what is captured in binlog but it still in statement based,



SET TIMESTAMP=1234760963/*!*/;
BEGIN
/*!*/;
# at 847
#090216 13:09:23 server id 1  end_log_pos 961   Query   thread_id=6     exec_time=0     error_code=0
SET TIMESTAMP=1234760963/*!*/;
delete from address where id >450001 and id <450116
/*!*/;
# at 961
#090216 13:09:23 server id 1  end_log_pos 988   Xid = 40
COMMIT/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;


<div>
Did you try this at your end? pls let me know.<br />
<br />
Thanks,<br />
Umesh
</div>


Did you try this at your end? pls let me know.

Thanks,
Umesh

<div>
<div class="content wysiwyg-content">
Currently I have already enabled binary log as statement base logging, how do I enable binary logs as row base logging
</div>
</div>


Currently I have already enabled binary log as statement base logging, how do I enable binary logs as row base logging

Mysql, How to enable row based log

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.