MySQL backup script

#!/bin/bash#time:2016-11-8#owner:fujinzhou#scriptname:mysqlback.sh# the name of the database to be backed up, multiple databases are separated by spaces db= (Zabbix reboot10) # Backup directory Backuppath= "/data/backup/" if [!-D "$BACKUPPATH"]; Then Mkdir-p "$BACKUPPATH" fi# loop dbfor db in ${db[*]} do CD $BACKUPPATH #备份并打包数据库生成的sql文件/bin/nice-n 19/usr /bin/mysqldump--defaults-file=/root/.my.cnf $db > ${db}_$ (Date +%y%m%d). SQL && tar zpcf ${db}_$ (date +%y%m%d ). sql.tar.gz ${db}_$ (date +%y%m%d). SQL done# Delete the previous SQL file Rm-rf $BACKUPPATH *.sql

This article from "Do not abandon!" Do not give up "blog, be sure to keep this source http://thedream.blog.51cto.com/6427769/1870676

MySQL backup script