/usr/local/mysql55/bin/mysqlbinlog -vv mysql-bin.000064 –base64-output=DECODE-ROWS –start-datetime=’2017-09-16 00:00:00’ –stop-datetime=’2017-10-17 17:00:00’ | grep -A 20 “3F2D28FF-0254-4EEE-9B8C-024D7923AA92”
grep -A 是关键词的作用是显示数据20行
/usr/local/mysql55/bin/mysqlbinlog -vv mysql-bin.000064 –base64-output=DECODE-ROWS –start-datetime=’2017-09-16 00:00:00’ –stop-datetime=’2017-10-17 17:00:00’ | grep -A 20 “3F2D28FF-0254-4EEE-9B8C-024D7923AA92”
grep -A 是关键词的作用是显示数据20行