Mysql Dump via Crontab

Databases
1

Hi

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?

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.