How can I download binary logs from an Amazon RDS MySQL DB instance?

1 minute read

I want to download binary logs from an Amazon Relational Database Service (Amazon RDS) MySQL DB instance.


1.    If you haven't done so already, install the mysqlbinlog utility on your client machine:

sudo yum install -y mysql

2.    Connect to your RDS DB instance from the MySQL client.

3.    Run the SHOW BINARY LOGS (on the Maria DB website) command on the RDS DB instance and review the output. The output includes a list of the binary logs that are present on the RDS DB instance. The output looks similar to the following:

mysql> show binary logs;
| Log_name                   | File_size |
| mysql-bin-changelog.068462 |       729 |
| mysql-bin-changelog.068463 |       578 |
| mysql-bin-changelog.068464 |       578 |
| mysql-bin-changelog.068465 |       154 |
4 rows in set (0.00 sec)

4.    Access the MySQL binary logs to download or stream the logs from your RDS DB instance.

Related Information

How do I download my Amazon RDS DB instance logs?