crontab执行mysql备份，但是没有生成备份文件

litigerking

我配置定时执行任务备份mysql,在命令行执行能正常备份，但是放在crontab后，却没有备份，看日志crontab是正常执行了脚本的，也没有错误提示，

crontab加的

1. 15      8       *       *       *       root    /home/mysqlbackup/mysqlbackup.sh

复制代码

mysqlbackup.sh内容

1. 
   
2. #!/bin/sh
   
3. db_user="tiger"
   
4. db_passwd="tiger"
   
5. db_host="localhost"
   
6. 
   
7. # directory for backup files.
   
8. backup_dir="/home/mysqlbackup"
   
9. 
   
10. # delete backup files created expdays ago
    
11. expdays=100
    
12. 
    
13. # date format for backup files (yyyy-mm-dd)
    
14. time="$(date +"%Y-%m-%d")"
    
15. 
    
16. # a comma delimited list of databases to backup, backup all databases if blank
    
17. dblist="tiger"
    
18. 
    
19. # get full path and name for the following programs
    
20. MYSQL="$(which mysql)"
    
21. if [ -z $MYSQL ]; then
    
22. echo "mysql not found ..."
    
23. exit 0
    
24. fi
    
25. MYSQLDUMP="$(which mysqldump)"
    
26. if [ -z $MYSQLDUMP ]; then
    
27. echo "mysqldump not found ..."
    
28. exit 0
    
29. fi
    
30. MKDIR="$(which mkdir)"
    
31. RM="$(which rm)"
    
32. GZIP="$(which gzip)"
    
33. ###########END-USER-DEFINE###########
    
34. 
    
35. # create backup root directory if not found
    
36. test ! -d "$backup_dir/" && $MKDIR "$backup_dir/"
    
37. 
    
38. # check the directory for store backup is writeable
    
39. test ! -w $backup_dir && echo "Error: $backup_dir is un-writeable." && exit 0
    
40. 
    
41. # the directory for story the newest backup
    
42. test ! -d "$backup_dir/$time/" && $MKDIR "$backup_dir/$time/"
    
43. 
    
44. # get all databases
    
45. all_db="$($MYSQL -u $db_user -h $db_host -p$db_passwd -Bse 'show databases')"
    
46. 
    
47. for db in $all_db
    
48. do
    
49. goforit=$db
    
50. if [ ! -z "$dblist" ]; then
    
51. goforit=`echo ",$dblist," |grep ",$db,"`
    
52. fi
    
53. if [ ! -z "$goforit" ]; then
    
54. $MYSQLDUMP -u $db_user -h $db_host -p$db_passwd $db | $GZIP -9 > "$backup_dir/$time/$time.$db.gz"
    
55. fi
    
56. done
    
57. 
    
58. # delete the oldest backup
    
59. find $backup_dir -type d -mtime +$expdays -maxdepth 1 | xargs $RM -rf
    

复制代码

log记录

1. Jul 28 08:15:00 server2 /usr/sbin/cron[7088]: (root) CMD (/home/mysqlbackup/mysqlbackup.sh)
   

复制代码

litigerking

系统是FreeBSD 10 64位！

lsstarboy

文件开始为什么没有#!/bin/sh呢？

litigerking

没复制上，文件里有！
回复 3# lsstarboy


   

lsstarboy

手工执行报错吗？

litigerking

手工执行正常！
回复 5# lsstarboy


   

litigerking

这个脚本在8.3时用过，当时都很正常，现在就是不行！
回复 5# lsstarboy


   

lsstarboy

建议：
1、把which那几个换成绝对路径试试。
2、多加几个>>重定向，当调试信息写入到一个文件中。

litigerking

不管用，全部写成绝对路径，帐号密码全部写到命令行里，最后生成一个0字节的空文件，但是在命令行中执行都正常，就是放在crontab不行！回复 8# lsstarboy


   

cl101001000

回复 1# litigerking

不要加入用户试试。
‘15      8       *       *       *    /home/mysqlbackup/mysqlbackup.sh’