在/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 Create
basepath=
'/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 before
find
$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
