WebSVN - My Stuff - Path Comparison - / Rev 31 and / Rev 32

Ignore whitespace Rev 31 → Rev 32

 /trunk/Bash/mysql_backup.sh
 ,7 → 32,7
 do
         FILE=${BCKPATH}/mysql-${name}-$(date +"%d_%m_%y").sql
         echo "Creating backup of database ${name} to file ${FILE}"
-        if (${MYSQLDUMP} -u ${MYUSER} -p${PASSWORD} ${name} > ${FILE}) then
+        if (${MYSQLDUMP} -u ${MYUSER} -p${PASSWORD} ${name} >> ${FILE}) then
                 echo "Storing database ${name} in ${FILE} succesfull"
                 echo
         else

 /trunk/Bash/mysql_db_data_backup.sh
 ,10 → 30,13
   FILE=${BCKPATH}/mysql-data-${DATABASE}-$(date +"%d_%m_%y").sql
   echo "Creating backup of database ${DATABASE} to file ${FILE}"
-  if (${MYSQLDUMP} --skip-triggers --compact --no-create-info --disable-keys -u ${MYUSER} -p${PASSWORD} ${DATABASE} > ${FILE}) then
+  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