add single-transaction flag to mysqldump in example backup script.

Signed-off-by: Joshua Ferraro <jmf@liblime.com>

diff --git a/misc/cronjobs/backup.sh b/misc/cronjobs/backup.sh
index 940a9a0..38026cb 100755 (executable)
--- a/misc/cronjobs/backup.sh
+++ b/misc/cronjobs/backup.sh
@@ -5,7 +5,7 @@ KOHA_DATE=`date '+%y%m%d'`
 KOHA_DUMP=/tmp/koha-$KOHA_DATE.dump
 KOHA_BACKUP=/tmp/koha-$KOHA_DATE.dump.gz
 
-mysqldump -u koha -ppassword koha > $KOHA_DUMP &&
+mysqldump --single-transaction -u koha -ppassword koha > $KOHA_DUMP &&
 gzip -f $KOHA_DUMP &&
 # Creates the dump file and compresses it;
 # -u is the Koha user, -p is the password for that user.
@@ -20,4 +20,4 @@ chmod 600 /home/kohaadmin/koha-$KOHA_DATE.dump.gz &&
 echo "$KOHA_BACKUP was successfully created." | mail kohaadmin -s $KOHA_BACKUP ||
 echo "$KOHA_BACKUP was NOT successfully created." | mail kohaadmin -s $KOHA_BACKUP
 # Notifies kohaadmin of (un)successful backup creation
-# EOF
\ No newline at end of file
+# EOF