Shell scripts regularly back up the database

Script code:

New File back_db.sh

#!/bin/Bash Todaytime="' Date +%y%m%d '"DBNAME="test MySQL"Dumppath="/usr/local/webserver/mysql/bin/mysqldump"HOST="XXX"USER="XXX"PASSWD="XXX"Db_file="/home/data/backup/db_$todaytime.sql.gz" "$DUMPPATH"-H"$HOST"-U"$USER"-P"$PASSWD"--single-transaction--master-data=2-Q--databases $DBNAME |gzip>$DB _fileFind '/home/data/backup/'-name'db_*'-ctime +5|Xargs  RM-RF #删除5天前的文件

Deploying cron

Execute command:

Crontab–e–u Root;

Add the code below

1 1 * * * bash/home/data/cron/back_db.sh >/dev/null 2 >& 1 #每天早上的1点1分备份

Shell scripts regularly back up the database