Rev 31 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed
| Rev 31 | Rev 32 | ||
|---|---|---|---|
| Line 28... | Line 28... | ||
| 28 | exit 1 |
28 | exit 1 |
| 29 | fi
|
29 | fi
|
| 30 | 30 | ||
| 31 | FILE=${BCKPATH}/mysql-data-${DATABASE}-$(date +"%d_%m_%y").sql |
31 | FILE=${BCKPATH}/mysql-data-${DATABASE}-$(date +"%d_%m_%y").sql |
| 32 | echo "Creating backup of database ${DATABASE} to file ${FILE}" |
32 | echo "Creating backup of database ${DATABASE} to file ${FILE}" |
| 33 | if (${MYSQLDUMP} --skip-triggers --compact --no-create-info --disable-keys -u ${MYUSER} -p${PASSWORD} ${DATABASE} > ${FILE}) then |
- | |
| - | 33 | echo "SET FOREIGN_KEY_CHECKS = 0;" > ${FILE} |
|
| - | 34 | if (${MYSQLDUMP} --skip-triggers --compact --no-create-info --disable-keys -u ${MYUSER} -p${PASSWORD} ${DATABASE} >> ${FILE}) then |
|
| 34 | echo "Storing database ${DATABASE} in ${FILE} succesfull" |
35 | echo "Storing database ${DATABASE} in ${FILE} succesfull" |
| 35 | echo
|
36 | echo
|
| - | 37 | echo "SET FOREIGN_KEY_CHECKS =1;" >> ${FILE} |
|
| 36 | else
|
38 | else
|
| 37 | echo "Storing database ${DATABASE} in ${FILE} failed" |
39 | echo "Storing database ${DATABASE} in ${FILE} failed" |
| 38 | echo
|
40 | echo
|
| - | 41 | rm -rf ${FILE} |
|
| 39 | fi
|
42 | fi
|