使用mysqlbinlog时出错

lsl4437

各位高手，我在使用mysqlbinlog恢复二进制日志时，报错如下：
# mysqlbinlog --start-date='2009-07-01 11:28:00' --stop-date='2009-07-01 11:30:00'  localhost-bin.000025 |mysql -uroot -p***

ERROR 1064 (42000) at line 100: 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 '' at line 1
这是咋回事呢

枫影谁用了

呵呵，版本一致吗。先把sql重定向到文件再分析下那个语句的问题咯

bitterness

估计版本问题

lsl4437

我重定向到sql后进行恢复，依然报错
Query OK, 0 rows affected (0.00 sec)

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 '' at line 1

lsl4437

这是我的版本
# /usr/local/mysql/bin/mysql --version
/usr/local/mysql/bin/mysql  Ver 14.14 Distrib 5.1.24-rc, for redhat-linux-gnu (i686) using readline 5.1
You have new mail in /var/spool/mail/root
# /usr/local/mysql/bin/mysqlbinlog --version
/usr/local/mysql/bin/mysqlbinlog Ver 3.3 for redhat-linux-gnu at i686

bitterness

那不是版本的问题，检查下那条语句，手动执行下呢

lsl4437

这是部分导成sql中语句，咋看那条语句报的错呢
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#090701 11:28:44 server id 31810  end_log_pos 106       Start: binlog v 4, server v 5.1.24-rc-log created 090701 11:28:44
BINLOG '
7NdKSg9CfAAAZgAAAGoAAAAAAAQANS4xLjI0LXJjLWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC
'/*!*/;
# at 106
#090701 11:28:46 server id 31810  end_log_pos 174       Query   thread_id=301   exec_time=0     error_code=0
use orca/*!*/;
SET TIMESTAMP=1246418926/*!*/;
SET @@session.pseudo_thread_id=301/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1/*!*/;
SET @@session.sql_mode=2097152/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C utf8 *//*!*/;
SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=33/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
BEGIN
/*!*/;
# at 174
# at 300
#090701 11:28:46 server id 31810  end_log_pos 300       Table_map: `orca`.`ALARM_EVENT` mapped to number 3330
#090701 11:28:46 server id 31810  end_log_pos 726       Update_rows: table id 3330 flags: STMT_END_F

BINLOG '
7tdKShNCfAAAfgAAACwBAAAAAAINAAAAAAAABG9yY2EAC0FMQVJNX0VWRU5UACAIDwcQDw8CAgcH
Dw8Q/PwQDw8QBw8PDw8PDw8PDwICCCr9AgAB/QL9AvAA8AAAAQICAAH9Av0CAAH9Av0C/QL9Av0C
/QL9Av0C/QL6////
7tdKShhCfAAAqgEAANYCAAAQAAINAAAAAAEAIP//////////AC/rB1EAAAAAAAAABgAxMjAwMjDr
10pKAQQANDAuMB4AaG9zdGlkPWNsdXN0ZXIxLGlwPTEwLjEwLjcuMTE0BQD//wAmAG1lbW9yeV91
c2FnZT05NjQvMTAwN00sZnJlZV9tZW1vcnk9NDNNAAEAACUAMTIwMDIwOmhvc3RpZD1jbHVzdGVy
MSxpcD0xMC4xMC43LjExNB4AaG9zdGlkPWNsdXN0ZXIxLGlwPTEwLjEwLjcuMTE0AgABAP//////
////AC/rB1EAAAAAAAAABgAxMjAwMjDu10pKAQQAMzcuMB4AaG9zdGlkPWNsdXN0ZXIxLGlwPTEw
LjEwLjcuMTE0BQD//wAmAG1lbW9yeV91c2FnZT05NjQvMTAwN00sZnJlZV9tZW1vcnk9NDNNAAEA
ACUAMTIwMDIwOmhvc3RpZD1jbHVzdGVyMSxpcD0xMC4xMC43LjExNB4AaG9zdGlkPWNsdXN0ZXIx
LGlwPTEwLjEwLjcuMTE0AgABAP//////////
'/*!*/;
# at 726
#090701 11:28:46 server id 31810  end_log_pos 753       Xid = 12851090
COMMIT/*!*/;

lsl4437

那位帮指点一下啊

bitterness

你是针对同一版本或相近版本导数据的么？

lsl4437

同一版本，就是同一个数据库