MySQL scheduled database backup operation example

root@laowang:/# which mysqldump
/usr/bin/mysqldump

root@laowang:/# vim /etc/my.cnf

[mysqldump]
user=root
password=root

root@laowang:/var/backups# vim mysql_backup.sh
#!/bin/sh
#################################################
# Back up the database###################################################
#mysqldump backup program execution path DUMP=/usr/bin/mysqldump
#Backup file storage path OUT_DIR=/var/database
#Backup file permissions LINUX_USER=root
#The name of the database to be backed up DB_NAME=laowang
#Backup days, delete previous DAYS=1

#Enter the backup storage directory cd $OUT_DIR
#Get the current system time DATE=`date +%Y_%m_%d`
#Backup database file name OUT_SQL=$DB_NAME"_$DATE.sql"
#The final saved database backup file name TAR_SQL=$DB_NAME"_$DATE.tar.gz"
#Start backing up the database $DUMP --defaults-extra-file=/etc/my.cnf --default-character-set=utf8 $DB_NAME > $OUT_SQL

#Compress to .tar.gz format tar -czf $TAR_SQL ./$OUT_SQL
#Delete the backup file in .sql format rm $OUT_SQL
#Change the owner of the backup database file chown $LINUX_USER:$LINUX_USER $OUT_DIR/$TAR_SQL
#Delete the backup files from 30 days ago (note: there is a space between {} \;)
find $OUT_DIR -name "*.tar.gz" -type f -mtime +$DAYS -exec rm -f {} \;

root@laowang:/# crontab -e
# mh dom monitor command
10 10 * * * /var/backups/mysql_backup.sh