服务器生成的二进制日志文件写成二进制格式。要想检查这些文本格式的文件,应使用mysqlbinlog实用工具。 应这样调用mysqlbinlog: shell> mysqlbinlog [options] log-files... 例如,要想显示二进制日志binlog.000003的内容,使用下面的命令: shell> mysqlbinlog binlog.0000003 输出包括在binlog.000003中包含的所有语句,以及其它信息例如每个语句花费的时间、客户发出的线程ID、发出线程时的时间戳等等。...
by atyu30 - BSD文档中心 - 2007-11-06 15:53:00 阅读(1870) 回复(0)
服务器生成的二进制日志文件写成二进制格式。要想检查这些文本格式的文件,应使用mysqlbinlog实用工具。 应这样调用mysqlbinlog: shell> mysqlbinlog [options] log-files... 例如,要想显示二进制日志binlog.000003的内容,使用下面的命令: shell> mysqlbinlog binlog.0000003 输出包括在binlog.000003中包含的所有语句,以及其它信息例如每个语句花费的时间、客户发出的线程ID、发出线程时的时间戳等等。 通常情况,可以使用m...
ERROR: Error in Log_event::read_log_event(): 'Found invalid event in binary log', data_len: 94, event_type: 15 Could not read entry at offset 4:Error in log format or read error 麻烦那位高手指点一下,谢谢了
mysqlbinlog:Utility for Processing Binary Log Files The binary log files that the server generates are written in binary format. To examine these files in text format, use the mysqlbinlog utility. Invoke mysqlbinlog like this: shell> mysqlbinlog [options] log-file ... For example, to display the contents of the binary log binlog.000003, use this command: shell> mysqlbinlog binlog.0000003 The o...
使用网上说的 /mysqlbinlog --stop-date="2008-10-15 08:00:00" /var/log/mysql/bin.123456 恢复数据 但是运行以后 出现一堆的数据 然后再次查询数据的时候还是没有恢复啊????????急求市什么原因呢???
[root@test ~]# mysqlbinlog mysql-bin.000005 /*!40019 SET @@session.max_insert_delayed_threads=0*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; # at 4 #090817 9:37:00 server id 2 end_log_pos 106 Start: binlog v 4, server v 5.1.37-log created 090817 9:37:00 at startup ROLLBACK/*!*/; BINLOG ' PLSISg8CAAAAZgAAAGoAAAAAAAQANS4xLjM3LWxvZwAAAAAAAAAAAAAAA...
各位高手,我在使用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 这是咋回事呢
mysqlbinlog在处理bin-log中重要的选项 --start-datetime=name Start reading the binlog at first event having a datetime equal or posterior to the argument; the argument must be a date and time in the local time zone, in any format accepted by the MySQL server for DATETIME and TIMESTAMP typ...
通过mysqlbinlog 导出来的日志文件,mysql如论如何都认不到 mysqlbinlog mysql-bin.000067 >xxx.sql mysqlbinlog xxx.sql 这里就报错了 ERROR: File is not a binary log file mysqlbinlog --start-position=433760210 --stop-position=433761222 mysql-bin.000067 >xx.sql mysqlbinlog xx.sql 也是报一样错 ERROR: File is not a binary log file 哪位兄台遇到过类似问题,请教下,在线等!
我使用命令: root@supporthost mysql]# /usr/bin/mysqlbinlog -h192.168.55.55 -uroot -R --to-last-log /var/lib/mysql/1.000001 但得到的结果是: /*!40019 SET @@session.max_insert_delayed_threads=0*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; Got error reading packet from server: Could not find first log file name in binary log index file # End of log file ROLLBACK /* adde...
1.查看Binlog的相关属性 mysql> show binlog events\G *************************** 1. row *************************** Log_name: mysql-bin.000001 Pos: 4 Event_type: Format_desc Server_id: 1 End_log_pos: 106 Info: Server ver: 5.1.26-rc-log, Binlog ver: 4 1 row in set (0.01 sec) 本文来自ChinaUnix博客,如果查看原文请点:http://blog.chinaunix.net/u/11598/showart_1162317.html