標題: sh -n 提示語法錯誤，檢查不出那地方有錯誤。。。 [打印本頁] 作者: zhmysh 時間: 2010-09-02 16:11 標題: sh -n 提示語法錯誤，檢查不出那地方有錯誤。。。 本帖最后由 zhmysh 于 2010-09-02 16:20 編輯
腳本如下：
#!/bin/bash
cd /home/bak_call_log
#deal with call_log table and record operation log
baktable {
local baktime=$1
/usr/local/mysql/bin/mysql -uroot -pxxxxx -e"use aps;create table call_log_${baktime} select * from call_log where start_time <'"${baktime}"-01 00:00:00';"
if [ $? = 0 ]
then
echo "`date +%Y-%m-%d-%T` sucess for create table">>/home/bak_call_log/call_log_bak.log
else
echo "`date +%Y-%m-%d-%T` no sucess for create table">>/home/bak_call_log/call_log_bak.log
exit 1
fi
sleep 7
/usr/local/mysql/bin/mysql -uroot -pxxxxx -e"use aps;delete from call_log where start_time <'"${baktime}"-01 00:00:00';"
if [ $? = 0 ]
then
echo "`date +%Y-%m-%d-%T` sucess for delete record">>/home/bak_call_log/call_log_bak.log
else
echo "`date +%Y-%m-%d-%T` no sucess for delete record">>/home/bak_call_log/call_log_bak.log
exit 1
fi
sleep 7
/usr/local/mysql/bin/mysqldump -uroot -pxxxxx --opt aps call_log_${baktime} |gzip >/home/bak_call_log/call_log_${baktime}.sql.gz
if [ $? = 0 ]
then
echo "`date +%Y-%m-%d-%T` sucess for bak file">>/home/bak_call_log/call_log_bak.log
else
echo "`date +%Y-%m-%d-%T` no sucess for bak file">>/home/bak_call_log/call_log_bak.log
exit 1
fi
sleep 7
/usr/local/mysql/bin/mysql -uroot -pxxxxx -e"use aps;drop table call_log_${baktime};"
if [ $? = 0 ]
then
echo "`date +%Y-%m-%d-%T` sucess for drop table">>/home/bak_call_log/call_log_bak.log
else
echo "`date +%Y-%m-%d-%T` no sucess for drop table">>/home/bak_call_log/call_log_bak.log
exit 1
fi
}
#這是第46行
# set date time
if [ `date +%m` -ne 01 || `date +%m` -ne 02 ]
then
btime=`date +%Y-%m |awk -F"-" '{$2=$2-2;print $1,0$2}'|sed 's/[[:space:]]/-/g'`
baktable $btime
sleep 1
else
btime=`date +%Y-%m |sed 's/0/1/2'`
baktable $btime
sleep 1
fi
[root@database bak_call_log]# sh -n call_log.sh
call_log.sh: line 45: syntax error near unexpected token `}'
call_log.sh: line 45: `} '
[root@database bak_call_log]# dos2unix call_log.sh
dos2unix: converting file call_log.sh to UNIX format ...
[root@database bak_call_log]# sh -n call_log.sh
call_log.sh: line 45: syntax error near unexpected token `}'
call_log.sh: line 45: `} '
[root@database bak_call_log]#