X-Git-Url: https://git.stderr.nl/gitweb?p=matthijs%2Fupstream%2Fbackupninja.git;a=blobdiff_plain;f=handlers%2Fmysql.in;h=c80a36a3d95881ba0aa8b4f8ba5fd20ec3efce05;hp=64b6f492188b31429ceb9249abd9c748fd68d99c;hb=2cfcdd636d21e353f061fdc563c4b6dee3a4d979;hpb=3cf6de437495495ea400ade55f7b13d4077b8cb3 diff --git a/handlers/mysql.in b/handlers/mysql.in index 64b6f49..c80a36a 100644 --- a/handlers/mysql.in +++ b/handlers/mysql.in @@ -10,6 +10,7 @@ getconf nodata getconf dbhost localhost getconf hotcopy no getconf sqldump no +getconf sqldumpoptions "--lock-tables --complete-insert --add-drop-table --quick --quote-names" getconf compress yes getconf vsname @@ -31,10 +32,7 @@ if [ $vservers_are_available = yes ]; 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 + vservers_running $vsname || fatal "The vserver $vsname is not running." # everything ok info "Using vserver '$vsname'." usevserver=yes @@ -238,7 +236,7 @@ then fatal "Authentication problem, maybe user/password is wrong or mysqld is not running?" fi else - databases=`echo 'show databases' | su $user -c "$MYSQL $defaultsfile" | grep -v Database` + databases=$(su $user -c "$MYSQL $defaultsfile -N -B -e 'show databases'" | sed 's/|//g;/\+----/d') if [ $? -ne 0 ] then fatal "Authentication problem, maybe user/password is wrong or mysqld is not running?" @@ -248,7 +246,7 @@ then for db in $databases do - DUMP_BASE="$MYSQLDUMP $defaultsfile --lock-tables --complete-insert --add-drop-table --quick --quote-names" + DUMP_BASE="$MYSQLDUMP $defaultsfile $sqldumpoptions" # Dumping structure and data DUMP="$DUMP_BASE $ignore $db"