edit-icon download-icon

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:

BINLOG ' 

MgI+UA8BAAAAZwAAAGsAAAAAAAQANS41LjI1LWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 

AAAAAAAAAAAAAAAAAAAyAj5QEzgNAAgAEgAEBAQEEgAAVAAEGggAAAAICAgCAA== 

'/*!*/; 

See the figure below:

δ.png

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.

.png

  

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

 

Thank you! We've received your feedback.