Вывод содержимого таблиц MySQL в файл
#!/bin/sh
min="300"
max="700"
MYSQL="/usr/local/bin/mysql --login-path=sessionscount -B radius"
while true
do
DATE=`date +%Y-%m-%d_%H:%M:%S`
q2="select count(vg_id) from sessionsradius"
s2=`echo $q2 | $MYSQL`
s3=`echo $s2| awk '{ print $2 }'`
out1=''
if [ "$s3" -lt "$min" ]; then
`$MYSQL -e 'select vg_id, session_id, parent_session_id, start_time, sess_ani, sess_dnis, id, updatetime, login from sessionsradius ;' > ./out-gt-$min.log`
out1=" !!! Min file was created"
fi
if [ "$s3" -gt "$max" ]; then
`$MYSQL -e 'select vg_id, session_id, parent_session_id, start_time, sess_ani, sess_dnis, id, updatetime, login from sessionsradius ;' > ./out-gt-$max.log`
out1=" !!! Max file was created"
fi
echo $DATE" : "$s2" "$out1
sleep 3
done;