mysqlbinlog: error writing file 'unopened'

[koenemy]

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

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

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

[koenemy]

应该是恢复这个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> </p><p>娴锋氮鏈夎捣鏈夎惤锛屼汉鐢熸湁楂樻湁浣庯紝閿€鍞湁澶氭湁灏戯紝鍐疯交鏃朵笉娑堟瀬锛岀伀鐖嗘椂涓嶅繕褰€傞偅涔堜綘鐨勬窐瀹濆簵锛?/p><p> </p><p>灏变細濡傚悓琛屾按娴佹按鑸紝灞圭珛鍦ㄦ窐瀹濅箣鏋楋紝寰堥毦鍊掍笅锛屽洜涓哄績鎬佸喅瀹氳涓恒€傝涓哄喅瀹氳鍔紝琛屽姩鍐冲畾閿€閲忋€?/p><p> </p><p> </p><p> </p><p> 鐜板湪鐨勬窐瀹濆簵鍍忔槸闆ㄥ悗鐨勬槬绗嬶紝涓€澶╅兘涓嶇煡閬撴湁澶氬皯瀹跺簵寮€涓氾紝浣嗘槸鎴戝湪杩欓噷瑕佽鐨勬槸寮€搴楀墠鎴戜滑婵€鎯呮編婀冿紝鎶辩潃涓€</p><p> </p><p>瀹氳鎴愬姛鐨勫績鎬佹潵鍒涗笟锛屼絾鏄線寰€鏈変簺搴楁槸寮€浜嗕竴娈垫椂闂翠箣鍚庯紝寮€搴楀墠鐨勯偅浜涙縺鎯呴兘涓嶇煡閬撴墦鍑荤殑鏄惁杩樻湁涓€lverlight, application/x-ms-application, application/x-ms-xbap, application/vnd.ms-xpsdocument, application/xaml xml, */* Referer: http://bbs.taobao.com/catalog/publish_thread/154503.htm 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)

[ACMAIN_CHM]

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

[koenemy]

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

[koenemy]

命令行里粘不全

惁杩樻湁涓€ 到这结束了，后边的粘不上 lverlight, application/x-ms-application,

[koenemy]

把日志转成sql文件，，，恢复到这句是什么 '\"' 这个错误 意思是可以是双引号有问题