edit-icon download-icon

Remotely obtaining the Binlog record from ApsaraDB for RDS for MySQL

Last Updated: Jul 13, 2016

 

1. Connect to ApsaraDB for RDS for MySQL and view its binlog file with either of the following commands:

show master logs;

or

show binary logs;

binary.png

2. Use the --read-from-remote-server parameter to remotely retrieve the mysql-bin.000497 file (for example) and save it to the local a.sql file.

mysqlbinlog  -umolan -p -hffffffffffffff.mysql.rds.aliyuncs.com --read-from-remote-server mysql-bin.000497 >a.sql.png

3. Open the binlog file and view the content.

.png

 

 

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

 

Thank you! We've received your feedback.