在/server/scripts/目录中创建备份脚本mysql_backup.sh
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
#!/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: mysql backup every day delete before 7days.# Notes: This plugin uses the "" command# ----------------------------# Copyright: 2016 (c) ywliyq# License: GPL# ----------------------------# Backup file is saved in the directory, if it does not exist Createbasepath='/data/mysql/backup/'
if [ ! -d "$basepath" ]; then
mkdir -p "$basepath"
fi# mysql bakcup to /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
# Delete the backup data to 7 days beforefind $basepath -mtime +7 -name "*.sql.gz" -exec rm -rf {} \;
|
===============================================================
创建定时任务，每天凌晨2点执行此脚本
# crontab -e
###### mysql backup at 2016/05/09 by ywliyq ######
0 2 * * * /bin/sh /server/scripts/mysql_backup.sh >/dev/null
本文转自 蜗牛远途 51CTO博客，原文链接:http://blog.51cto.com/ywliyq/1771371