X-Git-Url: https://git.stderr.nl/gitweb?a=blobdiff_plain;f=handlers%2Fmysql;h=6a8c3dd990a51c2849843709069baa9b2e1a7137;hb=9f9a16697883529f3271b3b44ab742b217726e2a;hp=4439bcc533173f84b9ca962ada281781d11f756e;hpb=ef78e14b29df0a9f010c3c2a07572bef5668d079;p=matthijs%2Fupstream%2Fbackupninja.git diff --git a/handlers/mysql b/handlers/mysql index 4439bcc..6a8c3dd 100644 --- a/handlers/mysql +++ b/handlers/mysql @@ -27,13 +27,13 @@ dumpdir="$backupdir/sqldump" # temporary ~/.my.cnf in root's home directory). if [ "$dbusername" != "" ]; then - home=`grep '^root' /etc/passwd | awk -F: '{print $6}'` + home=`grep '^root:' /etc/passwd | awk -F: '{print $6}'` [ -d $home ] || fatal "Can't find root's home directory ($home)." mycnf="$home/.my.cnf" if [ -f $mycnf ]; then # rename temporarily tmpcnf="$home/my.cnf.disable" - debug 0 "mv $mycnf $tmpcnf" + debug "mv $mycnf $tmpcnf" mv $mycnf $tmpcnf fi oldmask=`umask` @@ -60,31 +60,31 @@ fi if [ "$hotcopy" == "yes" ]; then if [ "$databases" == "all" ]; then execstr="$MYSQLHOTCOPY --quiet --allowold --regexp /.\*/./.\*/ $hotdir" - debug 0 "su $user -c '$execstr'" + debug "su $user -c '$execstr'" if [ ! $test ]; then output=`su $user -c "$execstr" 2>&1` code=$? if [ "$code" == "0" ]; then - debug 0 $output - debug 1 "Successfully finished hotcopy of all mysql databases" + debug $output + info "Successfully finished hotcopy of all mysql databases" else - debug 2 $output - debug 2 "Failed to hotcopy all mysql databases" + warning $output + warning "Failed to hotcopy all mysql databases" fi fi else for db in $databases; do execstr="$MYSQLHOTCOPY --allowold $db $hotdir" - debug 0 "su $user -c '$execstr'" + debug "su $user -c '$execstr'" if [ ! $test ]; then output=`su $user -c "$execstr" 2>&1` code=$? if [ "$code" == "0" ]; then - debug 0 $output - debug 1 "Successfully finished hotcopy of mysql database $db" + debug $output + info "Successfully finished hotcopy of mysql database $db" else - debug 2 $output - debug 2 "Failed to hotcopy mysql database $db" + warning $output + warning "Failed to hotcopy mysql database $db" fi fi done @@ -100,32 +100,32 @@ if [ "$sqldump" == "yes" ]; then for db in $databases; do execstr="$MYSQLDUMP --lock-tables --complete-insert --add-drop-table --quick --quote-names $db > $dumpdir/${db}.sql" - debug 0 "su $user -c '$execstr'" + debug "su $user -c '$execstr'" if [ ! $test ]; then output=`su $user -c "$execstr" 2>&1` code=$? if [ "$code" == "0" ]; then - debug 0 $output - debug 1 "Successfully finished dump of mysql database $db" + debug $output + info "Successfully finished dump of mysql database $db" else - debug 2 $output - debug 2 "Failed to dump mysql databases $db" + warning $output + warning "Failed to dump mysql databases $db" fi fi done if [ "$compress" == "yes" ]; then output=`$GZIP -f $dumpdir/*.sql 2>&1` - debug 0 $output + debug $output fi fi if [ "$dbusername" != "" ]; then ## clean up tmp config file - debug 0 "rm $mycnf" + debug "rm $mycnf" rm $mycnf if [ -f "$tmpcnf" ]; then - debug 0 "mv $tmpcnf $mycnf" + debug "mv $tmpcnf $mycnf" mv $tmpcnf $mycnf fi fi