查看 RDS binLog

Question

连接数据库

mysql -hrm-m5e39mf182j3rq3n590130.mysql.rds.aliyuncs.com -uyyxz -pyyxz -P3306

查看当前的 bin-log 文件

mysql> show master status;
+------------------+----------+--------------+------------------+------------------------------------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set                              |
+------------------+----------+--------------+------------------+------------------------------------------------+
| mysql-bin.000079 |  3129679 |              |                  | b1742218-22f6-11eb-bed4-00163e0654c4:1-3136052 |
+------------------+----------+--------------+------------------+------------------------------------------------+
1 row in set (0.00 sec)

输出 bin-log 到文件中

mysqlbinlog -uyyxz -pyyxz -hrm-m5e39mf182j3rq3n590130.mysql.rds.aliyuncs.com --read-from-remote-server mysql-bin.000079 --start-datetime="2020-11-28 17:59:00" --stop-datetime="2020-11-28 18:00:00" -vv --base64-output=decode-rows > mysql-bin.000079.log