创建一个单独的备份用户backup,不要用root
创建备份目录 :mkdir -p /databackup/fullbackup
1
|
mysql>
grant
SELECT
,RELOAD,SHOW DATABASES,SUPER,LOCK TABLES,REPLICATION CLIENT,SHOWVIEW,EVENT,FILE
on
*.*
to
backup@
'localhost'
identified
by
'MANAGER'
;
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
###### 备份数据库的脚本###############
##################
#author rrhelei@126.com#
#######90天备份过期自动删除###########
user=backup
passwd
=MANAGER
host=localhost
date
=Master_db_`
date
+%Y%m%d%H%M`
mysql_bin=
/usr/local/mysql/bin
$mysql_bin
/mysqldump-u
$user -p$
passwd
-h$host --single-transaction -A --master-data=2 >
/databackup/fullbackup/
$
date
.sql
if
[ -f
/databackup/fullbackup/
$
date
.sql ]
then
cd
/databackup/fullbackup
;
tar
-cvzf $
date
.sql.
tar
.gz $
date
.sql
rm
-fr $
date
.sql
fi
find
/databackup/fullbackup/
-
type
f -name
"*sql*"
-mtime +90|
xargs
rm
-fr {};
|
本文转自 dbapower 51CTO博客,原文链接:http://blog.51cto.com/suifu/1758022,如需转载请自行联系原作者