aboutsummaryrefslogtreecommitdiff
path: root/handlers/mysql
diff options
context:
space:
mode:
authorMicah Anderson <micah@riseup.net>2006-06-10 00:25:16 +0000
committerMicah Anderson <micah@riseup.net>2006-06-10 00:25:16 +0000
commitb5130c49410c6c1300b9c8f6246a61c4d1e66004 (patch)
tree1e5564c3d87a22b3d32e0b66c57096cedf7bdc09 /handlers/mysql
parent489e294c50b6cba7545a110d26edd43e6b6e55ea (diff)
downloadbackupninja-b5130c49410c6c1300b9c8f6246a61c4d1e66004.tar.gz
backupninja-b5130c49410c6c1300b9c8f6246a61c4d1e66004.tar.bz2
Added in-line compression to pgsql and mysql handlers, appears to work fine in tests
Diffstat (limited to 'handlers/mysql')
-rw-r--r--handlers/mysql19
1 files changed, 10 insertions, 9 deletions
diff --git a/handlers/mysql b/handlers/mysql
index 52193f4..a19509b 100644
--- a/handlers/mysql
+++ b/handlers/mysql
@@ -249,9 +249,17 @@ fi
do
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"
+ if [ "$compress" == "yes" ]; then
+ execstr="$VSERVER $vsname exec $MYSQLDUMP $defaultsfile --lock-tables --complete-insert --add-drop-table --quick --quote-names $ignore $db | $GZIP > $vroot$dumpdir/${db}.sql.gz"
+ else
+ execstr="$VSERVER $vsname exec $MYSQLDUMP $defaultsfile --lock-tables --complete-insert --add-drop-table --quick --quote-names $ignore $db > $vroot$dumpdir/${db}.sql"
+ fi
else
- execstr="$MYSQLDUMP $defaultsfile --lock-tables --complete-insert --add-drop-table --quick --quote-names $ignore $db > $dumpdir/${db}.sql"
+ if [ "$compress" == "yes" ]; then
+ execstr="$MYSQLDUMP $defaultsfile --lock-tables --complete-insert --add-drop-table --quick --quote-names $ignore $db | $GZIP > $dumpdir/${db}.sql.gz"
+ else
+ execstr="$MYSQLDUMP $defaultsfile --lock-tables --complete-insert --add-drop-table --quick --quote-names $ignore $db > $dumpdir/${db}.sql"
+ fi
fi
debug "su $user -c \"$execstr\""
if [ ! $test ]
@@ -268,13 +276,6 @@ fi
fi
fi
done
-
- if [ "$compress" == "yes" ]
- then
- output=`$GZIP -f $vroot$dumpdir/*.sql 2>&1`
- debug $output
- fi
-fi
# clean up tmp config file
if [ "$dbusername" != "" -a "$dbpassword" != "" ]