Centos7系统如何实时备份mysql【定时备份写sh脚本】

矫情吗；* 2021-09-30 11:50 460阅读 0赞

参考：[https://www.cnblogs.com/xiaoliu66007/p/4661044.html][https_www.cnblogs.com_xiaoliu66007_p_4661044.html]

参考：[https://www.cnblogs.com/zuidongfeng/p/9416226.html][https_www.cnblogs.com_zuidongfeng_p_9416226.html]

参考：[https://www.cnblogs.com/Andy0827/p/10311504.html][https_www.cnblogs.com_Andy0827_p_10311504.html]

#!/bin/bash
    date_time=`date +%Y%m%d%H%M`                #every minute
    database=wallet001              #database name
    user=root                       #database username
    password=123456                    #database password
    backup_path=/backup/mysqldata          #backup path
    
    #backup command
     
    /usr/bin/mysqldump -u${user} -p${password} ${database} > ${backup_path}/${database}_${date_time}.sql
    
    # 这里是仅保留最新7天的数据
    find ${backup_path} -mtime +7 -name "${database}_*.sql" -exec rm -f {} \;

shell脚本写完毕之后把他添加到centos的调度器中定时【或间隔】运行即可

crontab -e

添加一条规则：【这里设置的是间隔3小时备份一次】

0 */3 * * * /backup/database_backup_shell.sh

规则设置参考：[https://www.runoob.com/linux/linux-comm-crontab.html][https_www.runoob.com_linux_linux-comm-crontab.html]

[![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzM0MzE0NA_size_16_color_FFFFFF_t_70][]][https_www.runoob.com_linux_linux-comm-crontab.html]

[https_www.cnblogs.com_xiaoliu66007_p_4661044.html]: https://www.cnblogs.com/xiaoliu66007/p/4661044.html
[https_www.cnblogs.com_zuidongfeng_p_9416226.html]: https://www.cnblogs.com/zuidongfeng/p/9416226.html
[https_www.cnblogs.com_Andy0827_p_10311504.html]: https://www.cnblogs.com/Andy0827/p/10311504.html
[https_www.runoob.com_linux_linux-comm-crontab.html]: https://www.runoob.com/linux/linux-comm-crontab.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzM0MzE0NA_size_16_color_FFFFFF_t_70]: /images/20210812/6a3a667532d54e3aa53022c642112f09.png