Subversion Repositories My Stuff

#!/bin/bash

#####################################################################

# Script to make data copy from given mysql database

#

# 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}

DATABASE=${3}

BCKPATH=${4}

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

  FILE=${BCKPATH}/mysql-data-${DATABASE}-$(date +"%d_%m_%y").sql

  echo "Creating backup of database ${DATABASE} to file ${FILE}"

  echo "SET FOREIGN_KEY_CHECKS = 0;" > ${FILE}

  if (${MYSQLDUMP} --skip-triggers --compact --no-create-info --disable-keys -u ${MYUSER} -p${PASSWORD} ${DATABASE} >> ${FILE}) then

     echo "Storing database ${DATABASE} in ${FILE} succesfull"

     echo

     echo "SET FOREIGN_KEY_CHECKS =1;" >> ${FILE}

  else

     echo "Storing database ${DATABASE} in ${FILE} failed"

     echo

     rm -rf  ${FILE}

  fi