Db Profiles

plugins/localdump/mysql.sh

@@ -48,14 +48,14 @@ SOURCE_DIR=/var/lib/mysql
 # it sets mysql_FOUND as flag
 function mysql._check(){
 
-  j_requireBinary "mysql"             1
-  j_requireBinary "mysqldump"         1
-  j_requireProcess "mysqld|mariadb"   1
+  # j_requireBinary "mysql"             1
+  # j_requireBinary "mysqldump"         1
+  # j_requireProcess "mysqld|mariadb"   1
 
-  if [ ! -d $SOURCE_DIR ]; then
-    echo "INFO: directory $SOURCE_DIR doees not exist."
-    rc=$rc+1
-  fi
+  # if [ ! -d $SOURCE_DIR ]; then
+  #   echo "INFO: directory $SOURCE_DIR doees not exist."
+  #   rc=$rc+1
+  # fi
 
   # set flag and reset return code
   test $rc -eq 0 && mysql_FOUND=1
@@ -71,7 +71,7 @@ function mysql._check(){
 # param  string  name of the dabase scheme
 function mysql.db.create(){
   local _dbname=$1
-  echo "CREATE DATABASE IF NOT EXISTS \`${_dbname}\`;" | mysql
+  echo "CREATE DATABASE IF NOT EXISTS \`${_dbname}\`;" | mysql ${BACKUP_PARAMS}
   fetchrc >/dev/null
   test $myrc -eq 0 && mysql_COUNT_CREATE+=1
   test $myrc -eq 0 || mysql_COUNT_ERRORS+=1
@@ -89,14 +89,14 @@ function mysql.db.dump(){
   local _dbname=$1
   local _dumpfile=$2
 
-  mysqldump $LD_MYSQL_DUMP_PARAMS --result-file="$_dumpfile" "$_dbname" 2>&1
+  mysqldump ${BACKUP_PARAMS} $LD_MYSQL_DUMP_PARAMS --result-file="$_dumpfile" "$_dbname" 2>&1
   fetchrc >/dev/null
 
   if [ $myrc -eq 0 ]; then
         if ! zgrep -iE "(CREATE|INSERT)" "$_dumpfile" >/dev/null
         then
           typeset -i local _iTables
-          _iTables=$( mysql --skip-column-names --batch -e "use $_dbname; show tables ;" | wc -l )
+          _iTables=$( mysql ${BACKUP_PARAMS} --skip-column-names --batch -e "use $_dbname; show tables ;" | wc -l )
           if [ $_iTables -eq 0 ];
           then
             echo -n "EMPTY DATABASE ... "
@@ -120,7 +120,7 @@ function mysql.db.dump(){
 function mysql.db.import(){
   local _dumpfile=$1
   local _dbname=$2
-  zcat "$_dumpfile" | mysql "${_dbname}"
+  zcat "$_dumpfile" | mysql $BACKUP_PARAMS "${_dbname}"
   fetchrc >/dev/null
   test $myrc -eq 0 && mysql_COUNT_IMPORT+=1
   test $myrc -eq 0 || mysql_COUNT_ERRORS+=1
@@ -129,7 +129,7 @@ function mysql.db.import(){
 # show a list of existing databases
 function mysql.db.list(){
   # mysql -Ee "show databases ;" | grep "^Database:" | awk '{ print $2 }'
-  local _result=$( mysql -Ee "show databases ;" )
+  local _result=$( mysql ${BACKUP_PARAMS} -Ee "show databases ;" $BACKUP_PARAMS )
   fetchrc >/dev/null
   test $myrc -eq 0 && mysql_COUNT_DB=$( echo "$_result" | grep -c "^Database:" ) 
   test $myrc -eq 0 && echo "$_result" | grep "^Database:" | awk '{ print $2 }'
@@ -144,7 +144,8 @@ function mysql.db.list(){
 # USAGE: to abort a function if not available:
 # mysql.available || return
 function mysql.available(){
-  typeset -i local _rc=(1-$mysql_FOUND)
+  local _rc;
+  typeset -i _rc=(1-$mysql_FOUND)
   return $_rc
 }