Sample mysqldump database backup
[root@localhost mdata] # cat mysqlbacks backup.shallows backups Dir = `date +% F` [- d $BACKUP_DIR/$DATE_DIR] | | mkdir $BACKUP_DIR/$DATE_DIR-p & > / dev/nulltime= "$(date +"% Y-%m-%d ")" USER=PASS=PORT= # backup the database, full backup of DB_LIST=$ (/ mdata/mysql/bin/mysql-u$USER-p$PASS-P$PORT-s-e "show databases) "2 > / dev/null | egrep-v" Database | information_schema | mysql | performance_schema | sys ") for DB in $DB_LIST; do if! / mdata/mysql/bin/mysqldump-u$USER-p$PASS $DB > $BACKUP_DIR/$DATE_DIR/$DB-$ {time} .SQL 2 > / dev/null Then echo "$DATE_DIR $DB-$ {time} .sql backup failed" > / mdata/mysql/mysqlbackup.log fidone # delete backup DEL_DIR= `date-d "- 2 days" +% F` [- d $BACKUP_DIR/$DEL_DIR] & & rm-rf $BACKUP_DIR/$DEL_DIR# join the scheduled task (echo "1 01 * / mdata/mysql/mysql_backup.sh"; crontab-l) | crontab
Note: this is a binary installation, and the installation directory can also be changed to a variable for reference only.