diff options
Diffstat (limited to 'misc/rsnapshot/contrib/rsnapshot_backup_mysql')
| -rw-r--r-- | misc/rsnapshot/contrib/rsnapshot_backup_mysql | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/misc/rsnapshot/contrib/rsnapshot_backup_mysql b/misc/rsnapshot/contrib/rsnapshot_backup_mysql new file mode 100644 index 0000000000..5d75265d2c --- /dev/null +++ b/misc/rsnapshot/contrib/rsnapshot_backup_mysql @@ -0,0 +1,32 @@ +#!/bin/sh + +############################################################################## +# backup_mysql.sh +# +# by Nathan Rosenquist <nathan@rsnapshot.org> +# http://www.rsnapshot.org/ +# +# This is a simple shell script to backup a MySQL database with rsnapshot. +# +# The assumption is that this will be invoked from rsnapshot. Also, since it +# will run unattended, the user that runs rsnapshot (probably root) should have +# a .my.cnf file in their home directory that contains the password for the +# MySQL root user. For example: +# +# /root/.my.cnf (chmod 0600) +# [client] +# user = root +# password = thepassword +# host = localhost +# +# This script simply needs to dump a file into the current working directory. +# rsnapshot handles everything else. +############################################################################## + +# $Id: backup_mysql.sh,v 1.5 2005/04/03 13:52:02 scubaninja Exp $ + +# backup the database +/usr/bin/mysqldump --all-databases > mysqldump_all_databases.sql + +# make the backup readable only by root +/bin/chmod 600 mysqldump_all_databases.sql |