I'm trying to run two separate cron jobs.
The first one runs a php script that is supposed to update a mysql database. The script works fine when its run manually, but i wanted it to run as a cron.
i set the file to executable chmod 700, here's the line i put in the file.
0 0 * * * /usr/bin/lynx --dump http://ip/knowledge_base/athena/cust..._pnp_check.php
i checked my root mail for today and got this message:
/etc/cron.daily/expired_pnp: line 1: /dev/null/ is a directory
my other cron job i'm trying to set up is a mysql dump.
again i set hte file to executable and here is what is in the file:
mysqldump -uusername -ppassword --databases knowledge_db -c -e > /mnt/backups/`date +%m%d%y`.knowledge_db.sql
mysqldump -uusername -ppassword --databases knowledge_db -c -e | sendmail email@example.com
it couldn't send th email for some reason regarding the sendmail setup, but i got an error in my mail showing:
/etc/cron.dialy/knowledge_db_dump: line 3: /mnt/backups/091303.knowledge_db.sql: No such file or directory.
Any help would be greatly appreciated. I'm kinda pulling out my hair at this point.
Thanks in advance.