功能说明
每天早上4点,自动定时备份mysql的wordpress数据到/home/www/backup/blog
文件夹,并压缩成.sql.gz文件,同时检测30天前的备份,超过30天的,则删除。
创建文件夹
1
|
mkdir -p /home/www/shell
|
![](/images/2022/01/4ef5c791cd4142db5c29f0d6c8787fb9.png)
创建脚本文件:
vi /home/www/shell/mysql_backup_blog.sh
![](/images/2022/01/de591f75c1c759be5b6deaae905d11b4.png)
按下键盘的i键,进入编辑模式(这是屏幕底下显示–INSERT–,如果屏幕显示了i,按下Backspace退格键删除掉),复制下面内容,并粘贴
![](/images/2022/01/3a5c9fedb48eaedabbe485ec7192c777.png)
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
|
#!/bin/bash
#每天早上4点, mysql备份数据
#chmod 700 mysql_backup.sh
#crontab -e
#0 4 * * * /home/www/shell/mysql_backup_blog.sh
#!/bin/bash
# 设置mysql的登录用户名和密码(根据实际情况填写)
mysql_user="root"
mysql_password="你的mysql密码"
mysql_host="127.0.0.1"
mysql_port="3306"
mysql_charset="utf8mb4"
mysql_db_name="wordpress"
# 备份文件存放地址(根据实际情况填写)
backup_location=/home/www/backup/blog
# 是否删除过期数据
expire_backup_delete="ON"
expire_days=30
backup_time=`date +%Y%m%d%H%M`
backup_dir=$backup_location
welcome_msg="Welcome to use MySQL backup tools!"
# 判断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
# 判断备份目录是否存在,不存在则创建
if [ ! -d "$backup_dir" ];then
mkdir -p $backup_dir
fi
fi
# 备份指定数据库中数据(此处假设数据库是mysql_db_name)
mysqldump -h$mysql_host -P$mysql_port -u$mysql_user -p$mysql_password -B $mysql_db_name | gzip > $backup_dir/$mysql_db_name-$backup_time.sql.gz
flag=`echo $?`
if [ $flag == "0" ];then
echo "database $mysql_db_name success backup to $backup_dir/$mysql_db_name-$backup_time.sql.gz"
else
echo "database $mysql_db_name backup fail!"
fi
# 删除过期数据
if [ "$expire_backup_delete" == "ON" -a "$backup_location" != "" ];then
`find $backup_location/ -type f -mtime +$expire_days | xargs rm -rf`
echo "Expired backup data delete complete!"
fi
|
![](/images/2022/01/95c53f4f58e9d7cd77b06288b924d09b.png)
保存脚本
粘贴完成,按esc键,进入命令模式,输入下面命令,保存文件并退出
:wq
![](/images/2022/01/7cf3881a067d7f79d2e9e91d9dc457ef.png)
给脚本设置可执行权限
chmod 700 /home/www/shell/mysql_backup_blog.sh
![](/images/2022/01/98cf56c4b9d6af24895cd846c6af0007.png)
设置定时任务
crontab -e
![](/images/2022/01/5ca7d74079363aeb6c79adc39664f37d.png)
按下键盘的i键,进入编辑模式(这是屏幕底下显示–INSERT–,如果屏幕显示了i,按下Backspace退格键删除掉),复制下面内容,并粘贴
0 4 * * * /home/www/shell/mysql_backup_blog.sh
![](/images/2022/01/924ca5bfa783c6ebe300755d641f0129.png)
执行下面命令,保存并退出
:wq
现在定时在早上4点会执行备份任务。