Rev 7 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed
Rev 7 | Rev 32 | ||
---|---|---|---|
Line 30... | Line 30... | ||
30 | DATABASES="$(${MYSQL} -u ${MYUSER} -p${PASSWORD} -Bse 'show databases')" |
30 | DATABASES="$(${MYSQL} -u ${MYUSER} -p${PASSWORD} -Bse 'show databases')" |
31 | for name in ${DATABASES} |
31 | for name in ${DATABASES} |
32 | do
|
32 | do
|
33 | FILE=${BCKPATH}/mysql-${name}-$(date +"%d_%m_%y").sql |
33 | FILE=${BCKPATH}/mysql-${name}-$(date +"%d_%m_%y").sql |
34 | echo "Creating backup of database ${name} to file ${FILE}" |
34 | echo "Creating backup of database ${name} to file ${FILE}" |
35 | if (${MYSQLDUMP} -u ${MYUSER} -p${PASSWORD} ${name} > ${FILE}) then |
- | |
- | 35 | if (${MYSQLDUMP} -u ${MYUSER} -p${PASSWORD} ${name} >> ${FILE}) then |
|
36 | echo "Storing database ${name} in ${FILE} succesfull" |
36 | echo "Storing database ${name} in ${FILE} succesfull" |
37 | echo
|
37 | echo
|
38 | else
|
38 | else
|
39 | echo "Storing database ${name} in ${FILE} failed" |
39 | echo "Storing database ${name} in ${FILE} failed" |
40 | echo
|
40 | echo
|