mysql binlog配置

mysql my.cnf中binlog配置

# 开启binlog
log-bin=mysql-bin
server-id=1
binlog_format=ROW
#binlog显示原生语句
binlog_rows_query_log_events=1
#设置binlog清理时间
expire_logs_days = 7
#binlog每个日志文件大小
max_binlog_size = 500m

配置中配置了binlog_rows_query_log_events=1，才能查到原生语句

mysqlbinlog --no-defaults --base64-output=decode-rows -v -v --start-datetime="2021-09-10 00:00:00" --stop-datetime="2021-09-10 00:43:00" mysql-bin.000664 | grep -v ^### >/root/0910binlog.sql