Subversion Repositories My Stuff

#!/bin/bash

#####################################################################
# Script to make data copy from mysql
#
# This script is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
# Author: Andrzej Kardaś
# License: GPLv3
# The full version of the licencse can be obtainted by visiting:
# http://www.gnu.org/licenses/gpl.html
#######################################################################

MYUSER=${1}
PASSWORD=${2}
BCKPATH=${3}
MYSQL="/usr/bin/mysql"
MYSQLDUMP="/usr/bin/mysqldump"
  if [ -d ${BCKPATH} ]; then
       echo "Path seems ok"
       echo
  else
       echo "Can not find the provided path check script parameters"
       echo
       exit 1
  fi
  DATABASES="$(${MYSQL} -u ${MYUSER} -p${PASSWORD} -Bse 'show databases')"
  for name in ${DATABASES}
    do
      FILE=${BCKPATH}/mysql-data-${name}-$(date +"%d_%m_%y").sql
      echo "Creating backup of database ${name} to file ${FILE}"
      if (${MYSQLDUMP} --skip-triggers --compact --no-create-info --disable-keys -u ${MYUSER} -p${PASSWORD} ${name} > ${FILE}) then
        echo "Storing database ${name} in ${FILE} succesfull"
        echo
      else
        echo "Storing database ${name} in ${FILE} failed"
        echo
      fi
  done