Subversion Repositories My Stuff

Rev

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