mysql备份脚本(按天)
环境:mysql.5.7
#!/bin/sh
##目标库
username=
password=
database=
##备份还原库
username_bak=
passoword_bak=
database_bak=
ls_date=`date +%Y%m%d`
mkdir -p /home/SQL-OnlineBak/${ls_date}
mysqldump -h${username} -p${passoword} ${database} --set-gtid-purged=off > /home/SQL-OnlineBak/${ls_date}/ ${database}.sql
cd /home/SQL-OnlineBak/${ls_date}
mysql -u${username_bak} -p${passoword_bak} ${database_bak}< ${database}.sql
zip -r ${ls_date}.zip ${database}.sql
rm -rf /home/SQL-OnlineBak/${ls_date}/${database}.sql