misc/rsnapshot: Added to 12.0 repository

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