litigerking
发表于 2016-08-01 15:28
依然不行,只能生成0字节的空文件!回复 10# cl101001000
cl101001000
发表于 2016-08-01 15:39
回复 11# litigerking
你直接编辑的crontab配置文件还是-e操作的?
litigerking
发表于 2016-08-01 15:40
直接编辑的!回复 12# cl101001000
cl101001000
发表于 2016-08-01 15:48
回复 13# litigerking
方便粘出来看一下你的配置吗?
litigerking
发表于 2016-08-01 15:57
# Perform daily/weekly/monthly maintenance.
1 3 * * * root periodic daily
15 4 * * 6 root periodic weekly
47 5 1 * * root periodic monthly
#
# Adjust the time zone if the CMOS clock keeps local time, as opposed to
# UTC time.See adjkerntz(8) for details.
1,31 0-5 * * * root adjkerntz -a
52 * * * * root /home/webs/mysqlbackup/mysqlbackup
litigerking
发表于 2016-08-01 15:58
一楼就有!
回复 14# cl101001000
cl101001000
发表于 2016-08-01 16:30
回复 15# litigerking
这样也不行吗?你加几个错误输出吧,帮助定位一下是什么问题,还真没遇到过你这种情况
# Perform daily/weekly/monthly maintenance.
1 3 * * * root periodic daily
15 4 * * 6 root periodic weekly
47 5 1 * * root periodic monthly
#
# Adjust the time zone if the CMOS clock keeps local time, as opposed to
# UTC time.See adjkerntz(8) for details.
1,31 0-5 * * * root adjkerntz -a
52 * * * * /home/webs/mysqlbackup/mysqlbackup
lsstarboy
发表于 2016-08-01 17:35
文件名对了吗?如果文件名对了,说明gzip以后的命令正常,问题出在mysqldump部分。
把最核心的这句单独弄个sh测试一下,把变量都换成实际的字符串:
$MYSQLDUMP -u $db_user -h $db_host -p$db_passwd $db | $GZIP -9 > "$backup_dir/$time/$time.$db.gz"
lsstarboy
发表于 2016-08-01 17:35
回复 10# cl101001000
他这一个是放/etc/crontab里面的,不是用crontab -e。
litigerking
发表于 2016-08-02 08:43
换成实际的字符串,会生成0字节的备份文件!但是手动执行完全无错误!放在crontab中就不行,太奇怪了!回复 18# lsstarboy