在/server/scripts/目录中创建备份脚本mysql_backup.sh

#!/bin/bash#---------------------------#Filename:mysql_backup.sh#Revision:1.4#Date:2016/05/09#Author:ywliyq#Email:ywliyq@163.com#Website:http://ywliyq.blog.51cto.com/#Description:mysqlbackupeverydaydeletebefore7days.#Notes:Thispluginusesthe""command#----------------------------#Copyright:2016(c)ywliyq#License:GPL#----------------------------#Backupfileissavedinthedirectory,ifitdoesnotexistCreatebasepath='/data/mysql/backup/'if[!-d"$basepath"];thenmkdir-p"$basepath"fi#mysqlbakcupto/data/mysql/backup//application/mysql/bin/mysqldump-uroot-p'12345677'--events--ignore-table=mysql.events-F-B-A|gzip>$basepath/mysqlbak_$(date+%F).sql.gz#Deletethebackupdatato7daysbeforefind$basepath-mtime+7-name"*.sql.gz"-execrm-rf{}\;

===============================================================

创建定时任务，每天凌晨2点执行此脚本

# crontab -e

###### mysql backup at 2016/05/09 by ywliyq ######

0 2 * * * /bin/sh /server/scripts/mysql_backup.sh >/dev/null