#!/bin/bash
myuser=root
mypass=password
mycmd="/data/app/bin/mysql -u$myuser -p$mypass"
mydump="/data/app/bin/mysqldump -u$myuser -p$mypass"
#delete expired backup data
/bin/find /data/backup -mtime +90 -type f | xargs rm -rf
#backup mysql database
for database in `$mycmd -e "show databases ;"|grep -Evi "database|information_schema|performance_schema|sys|test"`
do
$mydump $database --skip-lock-tables --master-data=2 --single-transaction --flush-logs| gzip > /data/backup/${database}_$(date +%F).sql.gz
done
MYSQL 备份脚本(参考)
文章链接:https://www.qiansw.com/mysql-backup-script-reference.html
码字不易,转载请注明本文出处及文章链接。
码字不易,转载请注明本文出处及文章链接。
这篇文章还没有人留言,快来抢沙发吧。