Pull DML from MySQL binary logs (Optional time range)

getdml.sh

#!/bin/bash

## Pull INSERTs
/usr/local/mysql/bin/mysqlbinlog server-bin.1 --base64-output=DECODE-ROWS
 --start-datetime="YYYY-MM-DD HH:MM:SS" 
--stop-datetime="YYYY-MM-DD HH:MM:SS" 
-vv | grep -iI "INSERT INTO \`database-name" | sort -n | uniq -c | sort -rn

## Pull UPDATEs
/usr/local/mysql/bin/mysqlbinlog server-bin.1 --base64-output=DECODE-ROWS
 --start-datetime="YYYY-MM-DD HH:MM:SS" 
--stop-datetime="YYYY-MM-DD HH:MM:SS" 
-vv | grep -iI "UPDATE \`database-name" | sort -n | uniq -c | sort -rn

## Pull DELETEs
/usr/local/mysql/bin/mysqlbinlog server-bin.1 --base64-output=DECODE-ROWS
 --start-datetime="YYYY-MM-DD HH:MM:SS" 
--stop-datetime="YYYY-MM-DD HH:MM:SS" 
-vv | grep -iI "DELETE FROM \`database-name" | sort -n | uniq -c | sort -rn

## Grabs INSERT,DELETE,UPDATE as well as time
/usr/local/mysql/bin/mysqlbinlog server-bin.1 --base64-output=DECODE-ROWS
 --start-datetime="YYYY-MM-DD HH:MM:SS" 
--stop-datetime="YYYY-MM-DD HH:MM:SS" 
-vv | grep -B 1 -iI --no-group-separator "[INSERT INTO|DELETE|UPDATE] \`database-name\`"