How to catch mysqldump errors in scripted dump?

[Mike Lott]

Hi

Just a quick question. Is it possible to catch errors with mysqldump and redirect them to a file for processing? I have the following code section that I am using as part of automated dumps of the databases of a MySQL instance:

<snip>
pushd ${DUMP_DIR}
# Iterate through relevant databases and dump.
# First remove "Database" heading and "information_schema" database.
for i in $(mysql -e "show databases" -uroot|sed "/^Database$\|^information\_schema$/d")
do
mysqldump --opt --force ${i}>$(date +%Y%m%d)_${i}.sql
# compress with bzip
/usr/bin/bzip2 $(date +%Y%m%d)_${i}.sql
done
popd
</snip>

Obviously with the --force flag I want to keep the process running but need to be made aware of any errors that occur.

Thanks,

Mike