Mysql备份脚本
#!/bin/bash
DATE=`date "+%y-%m-%d"`
echo $DATE
BASEDIR=$(pwd)
echo $BASEDIR
BACKUP_DIR="$BASEDIR/$DATE"
if [ ! -d $BACKUP_DIR ]; then
mkdir $BACKUP_DIR
fi
cd $BACKUP_DIR
echo $(pwd)
# begin to backup
/server/mysql/bin/mysqldump -h127.0.0.1 -u root -pxxxxxx dbname > $BACKUP_DIR/dbname.sql