From fad67f6ef2f34d688c581b636d52e02620f0e72d Mon Sep 17 00:00:00 2001 From: Ryan Higgins Date: Mon, 2 Jun 2008 18:23:09 -0500 Subject: [PATCH] add single-transaction flag to mysqldump in example backup script. Signed-off-by: Joshua Ferraro --- misc/cronjobs/backup.sh | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/misc/cronjobs/backup.sh b/misc/cronjobs/backup.sh index 940a9a0b6b..38026cba6d 100755 --- 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 -- 2.39.5