Resolved MySQL Backup Cron Job - Empty DB File

[JohnnyU]

I run a backup of my website db every day and it worked fine in Plesk 12
Now i upgraded from Plesk 12 to Onyx and the job still works but the file created is empty

When i run this from the console it works and the db is created with normal sql file size but it doesn't work from Plesk cron - empty file!

Plesk reports that the command ran succesfully, there is no error. For user & pass i use the db connection, different from Plesk user & pass


This is my cron job: mysqldump -u MYUSER -pMYPASS DBNAME > /var/www/vhosts/MYDOMAIN.com/backup/backup_`date +\%d.\%m.\%Y`.sql

Also i tried this: mysqldump -u admin -p`cat /etc/psa/.psa.shadow` DBNAME > /var/www/vhosts/MYDOMAIN.com/backup/db_backup_`date +\%d\%m\%Y`.sql

 

[IgorG]

Try to specify full path to mysqldump.

 

[JohnnyU]

Working with: /usr/bin/mysqldump -u admin -p`cat /etc/psa/.psa.shadow` MYDB > /var/www/vhosts/MYSITE.com/backup/backup_`date +\%d.\%m.\%Y`.sql