Start/Stop mysql-sniffer and log data to file

start-mysql-sniffer

#!/bin/sh

APP="mysql-sniffer"
LOG="/tmp/mysql-sniffer.log"

PID=""

get_pid () {
        PID=`ps aux | grep "$APP" | grep -v grep | grep -v "$0" | awk '{ print $2 }'`
}

if [ "$1" = "-h" ];
then
        echo "Usage: $0 [options]"
        echo " -k = kill running script"
        echo " -h = Help"
        echo
        exit 0
fi

get_pid

if [ "$PID" != "" ];
then
        if [ "$1" = "-k" ];
        then
                echo "Stopping $APP (PID: $PID) ..."
                kill -9 $PID
        else
                echo "Already running $APP (PID: $PID)"
        fi
else
        nohup $APP -i=lo -u -v >> $LOG 2>&1 &
        get_pid
        echo "Running $APP (PID: $PID)"
        echo "- Logging to file: $LOG"
fi

Save file to /usr/bin directory then make executable:

chmod +x /usr/bin/start-mysql-sniffer