mysql备份shell脚本

# !bin/bash
cd H:/mysqlbak
echo "You are In Backup Directory"
mv backup* H:/mysqlbak/oldbackup
echo "Old Databases are Moved to oldbackup folder"
Now=$(date +"%Y-%m-%d-%H-%M-%S")
File=backup-blog-$Now.sql
Host=你的IP
Port=端口
# 备份表结构
mysqldump -h$Host -P$Port -u账号_ -p密码 -d 数据库名_ > $File
# 备份数据
mysqldump -h$Host -P$Port -u账号_ -p密码 -t 数据库名_ > $File
echo "Your Database Backup Successfully Completed"