my notes

Rsnapshot: backing up mysql databases

Install mysql-client if not installed, this will provide the mysqldump utility

# apt-get install mysql-client

# cp /usr/share/doc/rsnapshot/examples/utils/ /usr/local/bin/

Make sure your backup scripts are owned by root, and not writable by anyone else.

# chown root.root /usr/local/bin/
# chmod o-w /usr/local/bin/

This scripts is designed only to back up all databases to a single file.