mysql+自动备份权限_CentOS mysql web定时备份删除脚本与权限

一、backup.sh

脚本#/bin/bash

mysqldump --user=root --password='' --databases abc | gzip > /Back/www.dejaview.cn-`date +%Y%m%d%H%M`.sql.gz

tar czf abc.com-`date +%Y%m%d%H%M`.tar.gz /usr/local/nginx/html/abc.com

find /Back -name "*.gz" -mtime +7 -exec /bin/rm {} \;

文件属性：组root[0]，拥有者root[0]，777

二、web目录

文件属性：组root[0]，拥有者nobody[99]

三、nginx，php

两个均是nobody下运行

四、问题

目前mysql可以定时导出来，不过web目录无法压缩，也无法删除7天以前的压缩包

五、错误日志Feb 1 00:00:01 www CROND[6149]: (root) CMD (/usr/lib64/sa/sa1 -S DISK 1 1)

Feb 1 00:01:01 www CROND[6159]: (root) CMD (run-parts /etc/cron.hourly)

Feb 1 00:01:01 www run-parts(/etc/cron.hourly)[6159]: starting 0anacron

Feb 1 00:01:01 www anacron[6168]: Anacron started on 2013-02-01

Feb 1 00:01:01 www anacron[6168]: Jobs will be executed sequentially

Feb 1 00:01:01 www anacron[6168]: Normal exit (0 jobs run)

Feb 1 00:01:01 www run-parts(/etc/cron.hourly)[6170]: finished 0anacron

Feb 1 00:10:01 www CROND[6233]: (root) CMD (/usr/lib64/sa/sa1 -S DISK 1 1)

Feb 1 00:20:01 www CROND[6324]: (root) CMD (/usr/lib64/sa/sa1 -S DISK 1 1)

Feb 1 00:30:01 www CROND[6388]: (root) CMD (/usr/lib64/sa/sa1 -S DISK 1 1)

Feb 1 00:40:01 www CROND[6460]: (root) CMD (/usr/lib64/sa/sa1 -S DISK 1 1)

Feb 1 00:50:01 www CROND[6542]: (root) CMD (/usr/lib64/sa/sa1 -S DISK 1 1)

Feb 1 01:00:01 www CROND[6612]: (root) CMD (/usr/lib64/sa/sa1 -S DISK 1 1)

Feb 1 01:01:01 www CROND[6621]: (root) CMD (run-parts /etc/cron.hourly)

Feb 1 01:01:01 www run-parts(/etc/cron.hourly)[6621]: starting 0anacron

Feb 1 01:01:01 www anacron[6630]: Anacron started on 2013-02-01

Feb 1 01:01:01 www anacron[6630]: Jobs will be executed sequentially

Feb 1 01:01:01 www anacron[6630]: Normal exit (0 jobs run)

Feb 1 01:01:01 www run-parts(/etc/cron.hourly)[6632]: finished 0anacron

Feb 1 01:10:01 www CROND[6699]: (root) CMD (/usr/lib64/sa/sa1 -S DISK 1 1)

Feb 1 01:20:01 www CROND[6767]: (root) CMD (/usr/lib64/sa/sa1 -S DISK 1 1)

Feb 1 01:30:01 www CROND[6847]: (root) CMD (/usr/lib64/sa/sa1 -S DISK 1 1)

Feb 1 01:40:01 www CROND[6917]: (root) CMD (/usr/lib64/sa/sa1 -S DISK 1 1)

Feb 1 01:50:01 www CROND[6987]: (root) CMD (/usr/lib64/sa/sa1 -S DISK 1 1)

Feb 1 02:00:01 www CROND[7057]: (root) CMD (/usr/lib64/sa/sa1 -S DISK 1 1)

Feb 1 02:01:01