digadesign — 2010-05-10T18:22:14-04:00 — #1
I have spent the past 4 hours trying to figure this out. I trying to do a database backup with crontab.
I have got this to work from the command line but it doesnt work in the cron tab:
mysqldump -u dbuser -h localhost -pass dbname | gzip -9 > /var/www/vhosts/domain.com/httpdocs/backups/db`date +%m%d%y`.sql.gz
How can I place it in the cron tab section of Plesk to get it to work? What am I missing?
scallioxtx — 2010-05-11T05:27:25-04:00 — #2
Cron is probably unable to figure out where "mysqldump" is located, you should supply the full path.
Use "whereis mysqldump" on the command line to see where it is located.