<?xml version="1.0" encoding="UTF-8" ?>
<rss version="2.0">
<channel>
<title><![CDATA[linuxの飘扬]]></title> 
<link>https://www.linuxfly.org/index.php</link> 
<description><![CDATA[Power by www.linuxfly.org]]></description> 
<language>zh-cn</language> 
<copyright><![CDATA[linuxの飘扬]]></copyright>
<item>
<link>https://www.linuxfly.org/post//</link>
<title><![CDATA[[原]mysql 5.0更新日志的问题]]></title> 
<author>linuxing &lt;emos#linuxfly.org&gt;</author>
<category><![CDATA[Mysql]]></category>
<pubDate>Tue, 27 Dec 2005 06:32:49 +0000</pubDate> 
<guid>https://www.linuxfly.org/post//</guid> 
<description>
<![CDATA[ 
	&nbsp;&nbsp;昨天做数据库同步的时候，本来想用日志更新的方式做的，后来发现--log-update选项在my.cnf文件里面加入后，不能生效。<br/>&nbsp;&nbsp;到<a href="http://dev.mysql.com/doc/" target="_blank">http://dev.mysql.com/doc/</a>找5.0的文档看了一下，发现mysql5.0的更新树里面有这样一段话：<br/><div class="quote"><div class="quote-title">引用</div><div class="quote-content">Removed the update log. It is fully replaced by the binary log. If the MySQL server is started with --log-update, it is translated to --log-bin (or ignored if the server is explicitly started with --log-bin), and a warning message is written to the error log. Setting SQL_LOG_UPDATE silently sets SQL_LOG_BIN instead (or do nothing if the server is explicitly started with --log-bin). </div></div><br/>&nbsp;&nbsp;也就是说，mysql5.0下面已经用--log-bin代替了--log-update，并且my.cnf文件里面如果已经有log-bin定义的话，就会忽略log-update。难怪昨天的操作会不行。<br/>............<br/><br/>Tags - <a href="https://www.linuxfly.org/tags/linux/" rel="tag">linux</a> , <a href="https://www.linuxfly.org/tags/mysql/" rel="tag">mysql</a>
]]>
</description>
</item><item>
<link>https://www.linuxfly.org/post//#blogcomment</link>
<title><![CDATA[[评论] [原]mysql 5.0更新日志的问题]]></title> 
<author> &lt;user@domain.com&gt;</author>
<category><![CDATA[评论]]></category>
<pubDate>Thu, 01 Jan 1970 00:00:00 +0000</pubDate> 
<guid>https://www.linuxfly.org/post//#blogcomment</guid> 
<description>
<![CDATA[ 
	
]]>
</description>
</item>
</channel>
</rss>