mysqlbinlog: error writing file 'unopened' <errcode:22>

mysqlbinlog: error writing file 'unopened' <errcode:22>

这个错误谁遇到过,说是mysql版本问题。

日志是5.0备份的,用5.1。47恢复还是有这个问题。。

作者: koenemy   发布时间: 2011-06-15

应该是恢复这个SQL语句的时候出的错

insert cdb_posts (tid,subject,dateline,message,author,authorid,htmlon,attachment,fid,first) values ('1598073','寮€娣樺疂搴楅渶瑕佸ソ鐨勫績鎬?寮€搴楁病鍐呭姛锛屽氨寰堥毦鎴愬姛銆?,UNIX_TIMESTAMP('2011-06-11 20:53:06'),' <div class="article"> <div class="substance"> <div class=ke-post> <p>鍦ㄦ窐瀹濇贩浜嗛偅涔堝骞达紝鍙戠幇鍑犵偣锛岀幇鍦ㄥ垎浜笅锛屽笇鏈涘ぇ瀹朵笉瑕佹媿鐮栧晩銆?/p><p>&nbsp;</p><p>娴锋氮鏈夎捣鏈夎惤锛屼汉鐢熸湁楂樻湁浣庯紝閿€鍞湁澶氭湁灏戯紝鍐疯交鏃朵笉娑堟瀬锛岀伀鐖嗘椂涓嶅繕褰€傞偅涔堜綘鐨勬窐瀹濆簵锛?/p><p>&nbsp;</p><p>灏变細濡傚悓琛屾按娴佹按鑸紝灞圭珛鍦ㄦ窐瀹濅箣鏋楋紝寰堥毦鍊掍笅锛屽洜涓哄績鎬佸喅瀹氳涓恒€傝涓哄喅瀹氳鍔紝琛屽姩鍐冲畾閿€閲忋€?/p><p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;鐜板湪鐨勬窐瀹濆簵鍍忔槸闆ㄥ悗鐨勬槬绗嬶紝涓€澶╅兘涓嶇煡閬撴湁澶氬皯瀹跺簵寮€涓氾紝浣嗘槸鎴戝湪杩欓噷瑕佽鐨勬槸寮€搴楀墠鎴戜滑婵€鎯呮編婀冿紝鎶辩潃涓€</p><p>&nbsp;</p><p>瀹氳鎴愬姛鐨勫績鎬佹潵鍒涗笟锛屼絾鏄線寰€鏈変簺搴楁槸寮€浜嗕竴娈垫椂闂翠箣鍚庯紝寮€搴楀墠鐨勯偅浜涙縺鎯呴兘涓嶇煡閬撴墦鍑荤殑鏄惁杩樻湁涓€lverlight, application/x-ms-application, application/x-ms-xbap, application/vnd.ms-xpsdocument, application/xaml xml, */* Referer: [url]http://bbs.taobao.com/catalog/publish_thread/154503.htm[/url] Accept-Language: zh-cn Content-Type: application/x-www-form-urlencoded Accept-Encoding: gzip, deflate ThreadID: 3452 User-Agent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; SE 2.X MetaSr 1.0) Host: bbs.taobao.com Content-Length: 10145 Connection: Keep-Alive Cache-Control: no-cache Cookie: cookie2=26a9a4c1acbaaf7786ffafdd62e31233; uc1=lltime=1307776055</p> </div> </div> </div> ','20082008!',52579,1,0,273,1)

作者: koenemy   发布时间: 2011-06-15

直接把这个语句贴到MYSQL命令行工具中试一下呢?

作者: ACMAIN_CHM   发布时间: 2011-06-15