raymond blogs…

#!/bin/bash
# —————————————————-
#
# SQL Show Log version 1.0
# @author Raymond S. Usbal
# @usage sqlshowlog
#
# —————————————————-

### check parameter
E_NO_ARGS=65

if [ $# -eq 0 ]
then
echo “SQL Show Log version 1.0
Usage: sqlshowlog
”
exit $E_NO_ARGS
fi

### get latest MySQL log
for file in mysql-bin.??????*; do FLE_LATEST=$file; done;

### build start date string
START_DTE=$(date +%Y-%m-%d\ %k:$(($(date +%M) - $1)):%S)

mysqlbinlog –start-date=”$START_DTE” $FLE_LATEST \
| grep -v ‘^[#/]’ \
| grep -v ‘SET TIMESTAMP’ \
| grep -v ‘SET @@session’ \
| grep -v ‘DELIMITER’ \
| grep -v ‘ROLLBACK’ \
| sed ’s/\/\*!\*\///g’

### end