分享程序员开发的那些事...
更新时间：2022-09-26 09:34:59
mysql数据库备份脚本：
|
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
|
#!/bin/bash#定义变量信息USER=rootPASS=redhat12345 SOCKET=/data/3306/mysql.sock
CMD="mysql -u$USER -p$PASS -S $SOCKET"
DUMP="mysqldump --opt -u$USER -p$PASS -S $SOCKET"
DES="/usr/src/mysqlbackup"
BACKUPTIME="date +%F-%H:%M"
#目录判断if [ ! -d "$DES/`date +%F`" ];then
mkdir -p "$DES/`date +%F`"
fi#mysqldump备份数据库echo "----------------------------start backup mysql-------------------------------"
for database in `$CMD -e "show databases" | sed '1,2d' | egrep -v "mysql|schema"`
do$DUMP $database -B|gzip>$DES/`date +%F`/${database}.sql.gz
if [ $? -eq 0 ];then
echo "$database has been backup successful"
elseecho "$database has been not successful"
fi/bin/sleep 5
doneecho "---------------------------backup is end -------------------------------------"
|
执行结果如下：
|
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
|
[root@mysql-master mysqlbackup]# pwd
/usr/src/mysqlbackup[root@mysql-master mysqlbackup]# ll
总用量 4-rw-r--r-- 1 root root 805 12月 6 18:50 backup.sh[root@mysql-master mysqlbackup]# bash backup.sh
----------------------------start backup mysql-------------------------------dawnpro has been backup successfulhangzhou has been backup successfuljames has been backup successfulwanlong has been backup successful---------------------------backup is end -------------------------------------[root@mysql-master mysqlbackup]# ll
总用量 8drwxr-xr-x 2 root root 4096 12月 6 18:56 2016-12-06-rw-r--r-- 1 root root 805 12月 6 18:50 backup.sh[root@mysql-master mysqlbackup]# ll 2016-12-06/
总用量 16-rw-r--r-- 1 root root 512 12月 6 18:56 dawnpro.sql.gz-rw-r--r-- 1 root root 513 12月 6 18:56 hangzhou.sql.gz-rw-r--r-- 1 root root 511 12月 6 18:56 james.sql.gz-rw-r--r-- 1 root root 511 12月 6 18:56 wanlong.sql.gzmysql> show databases;+--------------------+| Database |+--------------------+| information_schema || dawnpro || hangzhou || james || mysql || performance_schema || wanlong |+--------------------+7 rows in set (0.00 sec)
|
做个简单的记录，后面有空再补充详细的注解或者对脚本进行优化