crontab執(zhí)行mysql備份，但是沒有生成備份文件

litigerking

我配置定時執(zhí)行任務備份mysql,在命令行執(zhí)行能正常備份，但是放在crontab后，卻沒有備份，看日志crontab是正常執(zhí)行了腳本的，也沒有錯誤提示，

crontab加的

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

復制代碼

mysqlbackup.sh內(nèi)容

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

系統(tǒng)是FreeBSD 10 64位！

lsstarboy

文件開始為什么沒有#!/bin/sh呢？

litigerking

沒復制上，文件里有！
回復 3# lsstarboy


   

lsstarboy

手工執(zhí)行報錯嗎？

litigerking

手工執(zhí)行正常！
回復 5# lsstarboy


   

litigerking

這個腳本在8.3時用過，當時都很正常，現(xiàn)在就是不行！
回復 5# lsstarboy


   

lsstarboy

建議：
1、把which那幾個換成絕對路徑試試。
2、多加幾個>>重定向，當調(diào)試信息寫入到一個文件中。

litigerking

不管用，全部寫成絕對路徑，帳號密碼全部寫到命令行里，最后生成一個0字節(jié)的空文件，但是在命令行中執(zhí)行都正常，就是放在crontab不行！回復 8# lsstarboy


   

cl101001000

回復 1# litigerking

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