- トノイテ、オ、、ソケヤ、マ、ウ、ホソァ、ヌ、ケ。」
- コス、オ、、ソケヤ、マ、ウ、ホソァ、ヌ、ケ。」
フワシ。
#Contents
**ウオヘラ [#mb24282b]
MySQL、ホ・ニ。シ・ヨ・ヌヒツサ、・チ・ァ・テ・ッ、ケ、・ケ・ッ・・ラ・ネ。」~
**サネ、、ハ [#u0663472]
**・ウ。シ・ノ [#k1d0b623]
-mysql-tablecheck.sh~
#!/bin/sh
# ------------------------
# MySQL Table Check Script
# ------------------------
# Version : 1.0
# date : 2009/12/09
export LANG=C
export PATH=/bin:/sbin:/usr/bin:/usr/sbin:$PATH
export PATH=/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/usr/local/mysql/bin
export LD_LIBRARY_PATH=:/usr/local/mysql/lib/mysql
## Setting
TABLELIST="mysql-tablecheck.txt"
MYSQLUSER="root"
MYSQLPASS="mysql"
DBNAME="zabbix"
## LogFile
MDATE=`date +%Y%m`
LOGPATH="/home/system/logs"
LOGFILE=$LOGPATH"/mysql-tablecheck_"$MDATE".log"
rm -f $LOGPATH"/mysql-tablecheck.log"
ln -s $LOGFILE $LOGPATH"/mysql-tablecheck.log"
## Perm Set
if [ -z $1 ]; then
LIST=$TABLELIST
else
LIST=$1
fi
if [ -f $LIST ]; then
TABLENAME=`cat $LIST | awk '{printf "%s, ",$1}END{print ";"}' | sed "s/. \;/ \;/g"`
else
exit 1
fi
if [ -z $2 ]; then
DB=$DBNAME
else
DB=$2
fi
## DEBUG
echo "use $DB; check table $TABLENAME"
## Exec
echo "------------------------------" >> $LOGFILE
date +%Y/%m/%d" "%H:%M:%S >> $LOGFILE
echo "------------------------------" >> $LOGFILE
echo "use $DB; check table $TABLENAME" |mysql -u $MYSQLUSER --password=$MYSQLPASS >> $LOGFILE
# EOF