All Products
Document Center

Binlog unreadable when queried via mysqlbinlog on ApsaraDB for RDS for MySQL

Last Updated: Jul 13, 2016


When mysqlbinlog -vv mysql-bin.000110 is used to view the binary file of ApsaraDB for RDS for MySQL, the following output is returned:





See the figure below:


The content in the red frame is not unreadable code but is the Base64-coded content. To decode it, you can add the following parameter when you use mysqlbinlog to view the binlog:

mysqlbinlog -vv --base64-output=decode-rows mysql-bin.000110

Then the decoded SQL log record is returned.



If the problem persists, contact Alibaba Cloud After-Sales Technical Support.