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
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
#!/bin/bash
#cript:mysqlbackup.sh
#Version:Release 2.0
#author:www.dba-china.com
#date:2011-10-27
#以下配置信息请自己修改
mysql_user= "root"  #MySQL备份用户
mysql_password= "password"  #MySQL备份用户的密码
mysql_host= "127.0.0.1"  #要备份的主机，一般为localhost
mysql_port= "3306"  #MySQL端口号，一般为3306
backup_db_arr=( "cms"  "ad" )  #要备份的数据库名称，多个用空格分开隔开 如("db1" "db2" "db3")
backup_location= '/home/lhb/backup_mysql_data'   #备份数据存放位置，末尾请不要带"/",此项可以保持默认，程序会自动创建文件夹
expire_backup_delete= "ON"  #是否开启过期备份删除 ON为开启 OFF为关闭
expire_days=40  #过期时间天数 默认为三天，此项只有在expire_backup_delete开启时有效
#以下配置请保持默认不要修改
backup_time=` date  +%Y%m%d%H%M`   #定义备份详细时间
backup_Ymd=` date  +%Y%m%d`  #定义备份目录中的年月日时间
backup_3ago=` date  -d  '3 days ago'  +%Y%m%d`  #3天之前的日期
backup_dir=$backup_location/$backup_Ymd   #备份文件夹全路径
welcome_msg= "Welcome to use MySQL backup tools!"  #欢迎语
#判断MYSQL是否启动,mysql没有启动则备份退出
mysql_ps=` ps  -ef | grep  mysql | wc  -l`
mysql_listen=` netstat  -an | grep  LISTEN | grep  $mysql_port| wc  -l`
if  [ [$mysql_ps == 0] -o [$mysql_listen == 0] ];  then
         echo  "ERROR:MySQL is not running! backup stop!"
         exit
else
         echo  $welcome_msg
fi
#连接到mysql数据库，无法连接则备份退出
mysql -h$mysql_host -P$mysql_port -u$mysql_user -p$mysql_password <<end
use mysql;
select  host,user from user where user= 'root'  and host= 'localhost' ;
exit
end
flag=` echo  $?`
if  [ $flag !=  "0"  ];  then
         echo  "ERROR:Can't connect mysql server! backup stop!"
         exit
else
         echo  "MySQL connect ok! Please wait......"
         #判断有没有定义备份的数据库，如果定义则开始备份，否则退出备份
         if  [  "$backup_db_arr"  !=  ""  ]; then
                 #dbnames=$(cut -d ',' -f1-5 $backup_database)
                 #echo "arr is (${backup_db_arr[@]})"
                 for  dbname  in  ${backup_db_arr[@]}
                 do
                                echo  "database $dbname backup start..."
                         ` mkdir  -p $backup_dir`
                         `mysqldump -h$mysql_host -P$mysql_port -u$mysql_user -p$mysql_password $dbname > $backup_dir/$dbname$backup_time.sql`
                         flag=` echo  $?`
                         if  [ $flag ==  "0"  ]; then
                                 echo  "database $dbname success backup to $backup_dir/$dbname$backup_time.sql"
                         else
                                 echo  "database $dbname backup fail!"
                         fi
                             
                 done
         else
                 echo  "ERROR:No database to backup! backup stop"
                 exit
         fi
         #如果开启了删除过期备份，则进行删除操作
         if  [  "$expire_backup_delete"  ==  "ON"  -a   "$backup_location"  !=  ""  ]; then
                 ` find  $backup_location/ - type  d -o - type  f -ctime +$expire_days - exec  rm  -rf {} \;`
         ` find  $backup_location/ - type  d -empty - exec  rm  -rf {} \;`
                  echo  "Expired backup data delete complete!"
         fi
         echo  "All database backup success! Think you!"
         exit
fi

本文转自birdinroom 51CTO博客，原文链接：http://blog.51cto.com/birdinroom/1402108，如需转载请自行联系原作者