mysql备份本
[root@c5-sc-vcollege-log01 deploy]# cat mysqlbak.sh
#!/bin/sh
TIMESTAMP=`date +%Y%m%d`
DAYSTAMP=`date +%Y%m`
## echo "start ...!"
echo $TIMESTAMP
echo $DAYSTAMP
DIR="/workspace/deploy/vcollegedb/${DAYSTAMP}"
echo $DIR
if ! test -d ${DIR}
then
mkdir -p ${DIR}
fi
/usr/bin/mysqldump -h 172.17.100.20 -umha_rep -p'6EEgSwYz8L$XD!8l' --single-transaction -R --force vcollegenew > ${DIR}/$TIMESTAMP.sql
echo "success!"
exit;