aboutsummaryrefslogtreecommitdiff
path: root/handlers/mysql
diff options
context:
space:
mode:
authorintrigeri <intrigeri@boum.org>2006-01-19 21:58:03 +0000
committerintrigeri <intrigeri@boum.org>2006-01-19 21:58:03 +0000
commitb52464c19e50b738902e3333172b67d2b7c503b7 (patch)
tree662b0e99633bcd35f1b1c721e22320f7acf08e1a /handlers/mysql
parentd600ba40c040c6a75a5b817f80184f60d9dc6eaf (diff)
downloadbackupninja-b52464c19e50b738902e3333172b67d2b7c503b7.tar.gz
backupninja-b52464c19e50b738902e3333172b67d2b7c503b7.tar.bz2
clean up and homogenize pgsql and mysql vserver checks
Diffstat (limited to 'handlers/mysql')
-rw-r--r--handlers/mysql65
1 files changed, 30 insertions, 35 deletions
diff --git a/handlers/mysql b/handlers/mysql
index d317930..3b82ddf 100644
--- a/handlers/mysql
+++ b/handlers/mysql
@@ -19,33 +19,28 @@ getconf dbpassword
getconf configfile /etc/mysql/debian.cnf
-# If vservers are configured, decide if the handler should
-# use them or if it should just operate on the host
-
-if [ "$vservers" = "yes" ]
-then
- if [ ! -z $vsname ]
- then
- info "Using vserver '$vsname'"
- usevserver=1
- else
- info "No vserver name specified, actions will be performed on the host"
- fi
-fi
-
-# If needed, make sure that the specified vserver exists and is running.
-if [ $usevserver ]
-then
- debug "Examining vserver '$vsname'"
- # does it exist ?
- vroot="$VROOTDIR/$vsname"
- [ -d $vroot ] || fatal "vserver '$vsname' does not exist at '$vroot'"
- # is it running ?
- $VSERVERINFO -q $vsname RUNNING
- if [ $? -ne 0 ]
- then
- fatal "vserver $vsname is not running."
- fi
+# Decide if the handler should operate on a vserver or on the host.
+# In the former case, check that $vsname exists and is running.
+local usevserver=no
+local vroot
+if [ $vservers_are_available = yes ]; then
+ if [ -z "$vsname" ]; then
+ # does it exist ?
+ if ! vservers_exist "$vsname" ; then
+ fatal "The vserver given in vsname ($vsname) does not exist."
+ fi
+ # is it running ?
+ $VSERVERINFO -q $vsname RUNNING
+ if [ $? -ne 0 ]; then
+ fatal "The vserver $vsname is not running."
+ fi
+ # everything ok
+ info "Using vserver '$vsname'."
+ usevserver=yes
+ vroot="$VROOTDIR/$vsname"
+ else
+ info "No vserver name specified, actions will be performed on the host."
+ fi
fi
## Prepare ignore part of the command
@@ -63,7 +58,7 @@ done
hotdir="$backupdir/hotcopy"
dumpdir="$backupdir/sqldump"
-if [ $usevserver ]
+if [ $usevserver = yes ]
then
[ "$sqldump" == "no" -o -d $vroot$dumpdir ] || $VSERVER $vsname exec mkdir -p $dumpdir
[ "$hotcopy" == "no" -o -d $vroot$hotdir ] || $VSERVER $vsname exec mkdir -p $hotdir
@@ -93,7 +88,7 @@ defaultsfile=""
if [ "$dbusername" != "" -a "$dbpassword" != "" ]
then
- if [ $usevserver ]
+ if [ $usevserver = yes ]
then
vhome=`$VSERVER $vsname exec getent passwd "root" | awk -F: '{print $6}'`
home="$vroot$vhome"
@@ -133,7 +128,7 @@ user=$dbusername
password="$dbpassword"
EOF
umask $oldmask
- if [ $usevserver ]
+ if [ $usevserver = yes ]
then
defaultsfile="--defaults-file=$vhome/.my.cnf"
else
@@ -147,7 +142,7 @@ if [ "$user" == "" ]; then
defaultsfile="--defaults-file=$configfile"
else
userset=true;
- if [ $usevserver ]
+ if [ $usevserver = yes ]
then
vuserhome=`$VSERVER $vsname exec getent passwd "$user" | awk -F: '{print $6}'`
if [ $? -eq 2 ]
@@ -177,7 +172,7 @@ then
info "Initializing hotcopy method"
if [ "$databases" == "all" ]
then
- if [ $usevserver ]
+ if [ $usevserver = yes ]
then
info "dbhost: $dbhost"
execstr="$VSERVER $vsname exec $MYSQLHOTCOPY -h $dbhost --quiet --allowold --regexp /.\*/./.\*/ $hotdir"
@@ -201,7 +196,7 @@ then
else
for db in $databases
do
- if [ $usevserver ]
+ if [ $usevserver = yes ]
then
execstr="$VSERVER $vsname exec $MYSQLHOTCOPY --allowold $db $hotdir"
else
@@ -233,7 +228,7 @@ then
info "Initializing SQL dump method"
if [ "$databases" == "all" ]
then
- if [ $usevserver ]
+ if [ $usevserver = yes ]
then
debug "echo show databases | $VSERVER $vsname exec su $user -c $MYSQL $defaultsfile | grep -v Database"
databases=`echo 'show databases' | $VSERVER $vsname exec su $user -c "$MYSQL $defaultsfile" | grep -v Database`
@@ -252,7 +247,7 @@ fi
for db in $databases
do
- if [ $usevserver ]
+ if [ $usevserver = yes ]
then
execstr="$VSERVER $vsname exec $MYSQLDUMP $defaultsfile --lock-tables --complete-insert --add-drop-table --quick --quote-names $ignore $db > $vroot$dumpdir/${db}.sql"
else