Install mysql-client if not installed, this will provide the mysqldump utility
Make sure your backup scripts are owned by root, and not writable by anyone else.
This scripts is designed only to back up all databases to a single file.
If you need to dump a single database use line below
Add script to rsnapshot
Edit rsnapshot config
Under BACKUP POINTS / SCRIPTS add following