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/backup_mysql.sh /usr/local/bin/

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

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

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

MySQL