#!/bin/bash args=$@ log_off() { mysql $args <<<"SET GLOBAL general_log = 'OFF'" echo 'set general_log off' } trap log_off SIGINT log_file=`mysql $args <<<"SHOW VARIABLES LIKE 'general_log_file'" | sed -n 2p | cut -f 2` mysql $args <<<"SET GLOBAL general_log = 'ON'" echo 'set general_log on' tail -f $log_file