centos7创建定时任务备份mysql数据库

一、编辑、查看

crontab -u root -e
crontab -l
systemctl status crontab

二、配置

0 2 * * * /usr/bin/backup_script.sh
#!/bin/bash

* * * * * /opt/backup_script.sh

0 1 * * * /opt/backup_script.sh
三、编写脚本
备份脚本

#!/bin/bash
BACKUP_DIR="/home/dbback"
DATABASE_NAME="student"
NOW=$(date +"%Y-%m-%d_%H-%M-%S")
FILE_NAME="$DATABASE_NAME-$NOW.sql"
mysqldump -u your_username -p'your_password' $DATABASE_NAME > $BACKUP_DIR/$FILE_NAME

恢复命令
mysql -h 172.16.10.184 -P3306 -u root -p"123456"
mysql>source $BACKUP_DIR/$FILE_NAME