(root)/trunk/Bash/mysql_db_data_backup.sh - Rev 32
Rev 31 |
Blame |
Compare with Previous |
Last modification |
View Log
| RSS feed
#!/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