mysql备份脚本

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;