Backing up your mysql instance can be a pain. The following two commands work great…
Your backup user only needs select and Lock table rights.
mysqldump -u username -p’password‘ -f –routines –add-drop-database table_name | bzip2 -c > /path/to/dump/location/filename.sql.bz2
And to get the stored procs
mysqldump -u username -p’password‘ -f -R –triggers –no-create-info –no-data –no-create-db –skip-opt database_name | bzip2 -c > /path/to/dump/location/filename.sql.bz2