参考:https://www.cnblogs.com/xiaoliu66007/p/4661044.html
参考:https://www.cnblogs.com/zuidongfeng/p/9416226.html
参考:https://www.cnblogs.com/Andy0827/p/10311504.html
#!/bin/bash
date_time=`date +%Y%m%d%H%M` #every minute
database=wallet001 #database name
user=root #database username
password=123456 #database password
backup_path=/backup/mysqldata #backup path
#backup command
/usr/bin/mysqldump -u${user} -p${password} ${database} > ${backup_path}/${database}_${date_time}.sql
# 这里是仅保留最新7天的数据
find ${backup_path} -mtime +7 -name "${database}_*.sql" -exec rm -f {} \;
shell脚本写完毕之后把他添加到centos的调度器中定时【或间隔】运行即可
crontab -e
添加一条规则:【这里设置的是间隔3小时备份一次】
0 */3 * * * /backup/database_backup_shell.sh
规则设置参考:https://www.runoob.com/linux/linux-comm-crontab.html