30,13 → 30,10 |
|
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 |
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 |