用bash脚本删除database的一张表

#!/bin/bash
# backup myhelpdesk database monthly.
backup_confirm() {
if [ $? -eq 0 ]
then
   echo "mysql backup successfully $(date +%Y%-m%-d)">>log/mysql.log
else
   echo "mysql backup failed $(date +%Y%-m%-d)">>log/mysql.log

fi

}

date=`date +%Y%-m%-d`
cd /database-backup

mysqldump -uuser -ppassword myhelpdesk ticket_table > backupfile.sql

tar -zcf ./backup$$-$(date +%Y%-m%-d).tar.gz backupfile.sql
backup_confirm

mysql -uuser -ppassword >>log/mysql.log 2>&1 << MAYDAY
use myhelpdesk
truncate table ticket_table;
exit
MAYDAY
backup_confirm