crontab执行脚本,能执行,但是没反应，没数据出来！

Antspirit

1. #!/usr/local/bin/bash
   
2. # mysql_backup.sh: backup mysql databases and keep newest 10 days backup.
   
3. # -----------------------------
   
4. db_user="root"
   
5. db_passwd="123456@321"
   
6. db_host="localhost"
   
7. 
   
8. # the directory for story your backup file.
   
9. backup_dir="/home/www/.backupDB"
   
10. 
    
11. # date format for backup file (dd-mm-yyyy)
    
12. time="$(date +"%Y-%m-%d")"
    
13. 
    
14. # mysql, mysqldump and some other bin's path
    
15. MYSQL="$(which mysql)"
    
16. MYSQLDUMP="$(which mysqldump)"
    
17. MKDIR="$(which mkdir)"
    
18. RM="$(which rm)"
    
19. MV="$(which mv)"
    
20. GZIP="$(which gzip)"
    
21. 
    
22. # check the directory for store backup is writeable
    
23. test ! -w $backup_dir && echo "Error: $backup_dir is un-writeable." && exit 0
    
24. 
    
25. 
    
26. # the directory for story the newest backup
    
27. test ! -d "$backup_dir" && $MKDIR "$backup_dir"
    
28. 
    
29. # get all databases
    
30. 
    
31. for db in bbs www haosite cacti
    
32. do
    
33.         $MYSQLDUMP -u $db_user -h $db_host -p$db_passwd $db | $GZIP -9 > "$backup_dir/$time.$db.gz"
    
34. done
    
35. 
    
36. #delete the oldest backup 10 days ago
    
37. find $backup_dir -name "*.gz" -mtime +10 |xargs rm -rf
    
38. 
    
39. exit 0;

复制代码

19  9    *    *    *   www   /home/www/.backupDB/backupDB.sh
这个多库备份脚本，直接执行是没有问题的，但是放在crontab里执行，只生成文件，但是没数据没有。
我的系统环境是BSD 8.2


特来请教大家。。。

Antspirit

草。。。

所有放在crontab里的脚本，能执行，但是没儿子出来。。。