I can not read mysql binary log

Question

When I try to view the binary log file on my free BSD server (/ var / lib / mysql / ib_logfile0) using mysqlbinlog using the following command:

I get an error "File is not a binary log file."

$ sudo mysqlbinlog -f ib_logfile0> ib_0.sql

After that, ib_0.sql contains:

{ /*!40019 SET @@session.max_insert_delayed_threads=0*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; ERROR: File is not a binary log file}

I checked that it is a binary file and I read that there is an innodb log file. Anyway, I cannot read this file, and I did not find any solution. Is there any other way to view this file?

Answer 1

, . , , .

Answer 2

, -f , , binlog.

mysqlbinlog binlog.000001 > filename.txt

: http://www.mydigitallife.info/how-to-read-mysql-binary-log-files-binlog-with-mysqlbinlog/