#!/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
