~# vim sql_log.sh
#!/bin/bash #echo $1 #echo $* #echo $@ #echo $# # Le nombre d'arguments : $# #echo $# var_on_off=""; if [ $# = 1 ] then if [ $1 = "ON" ] then var_on_off=$1; elif [ $1 = "OFF" ] then var_on_off=$1; else echo "Un seul ARG : ON/OFF"; exit 0; fi else echo "Un seul ARG : ON/OFF"; exit 0; fi var_general_log=`mysql --defaults-file=/etc/mysql/debian.cnf --skip-column-names -A information_schema -e "SELECT VARIABLE_VALUE FROM GLOBAL_VARIABLES WHERE VARIABLE_NAME = 'general_log'"` echo $var_general_log # general_log ON | OFF var_general_log_file=`mysql --defaults-file=/etc/mysql/debian.cnf --skip-column-names -A information_schema -e "SELECT VARIABLE_VALUE FROM GLOBAL_VARIABLES WHERE VARIABLE_NAME = 'general_log_file'"` echo $var_general_log_file # vmp090.log var_datadir=`mysql --defaults-file=/etc/mysql/debian.cnf --skip-column-names -A information_schema -e "SELECT VARIABLE_VALUE FROM GLOBAL_VARIABLES WHERE VARIABLE_NAME = 'datadir'"` echo $var_datadir echo "general_log:" $var_general_log $var_datadir$var_general_log_file if [ $1 = "ON" ] then :>$var_general_log_file fi mysql --defaults-file=/etc/mysql/debian.cnf --skip-column-names -e "SET GLOBAL general_log = $var_on_off" echo "tail -f $var_datadir$var_general_log_file"