LinuxQuestions.org - [SOLVED] rar produces 0-byte file in crontab

I have a .sh script that does a mysqldump of a database, uses RAR to compress it, and then deletes the .sql file.

It works perfectly when I run it manually from the command line, but when it runs in a cron the .rar file is always 0 bytes. I tried having it suppress all output but it didn't make a difference. Here is the file:

Code:

#!/bin/sh

filename="<path>/db_sh"

mysqldump -u <username> -p<password> --all-databases --skip-extended-insert > ${filename}.sql

/rar/rar a -iddpq -ierr ${filename}.rar ${filename}.sql > /dev/null 2>&1

unlink ${filename}.sql

*long path substituted with <path>

What can I do to make the cron version work? Thanks!