From fa0dab2c0c63b6526ad018798e1d60e554843ae7 Mon Sep 17 00:00:00 2001 From: Alex Buckley Date: Fri, 8 Apr 2022 08:10:04 +0000 Subject: [PATCH] Bug 30511: Don't lock up entire database while running koha-dump Test plan: 1. Apply the patch 2. Restart services 3. Run koha-dump 4. Confirm the .sql.gz and .tar.gz files are generated successfully Sponsored-by: Catalyst IT Signed-off-by: David Cook --- debian/scripts/koha-dump | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/debian/scripts/koha-dump b/debian/scripts/koha-dump index f3a6b5aed7..f8d2ad1fa1 100755 --- a/debian/scripts/koha-dump +++ b/debian/scripts/koha-dump @@ -79,13 +79,13 @@ dump_instance() then schemadump="$backupdir/$name-schema-$date.sql" [ "$quiet" = "no" ] && echo "* schema to $schemadump" - mysqldump $dbflag -d --host="$mysqlhost" \ + mysqldump $dbflag -d --host="$mysqlhost" --single-transaction \ --user="$mysqluser" --password="$mysqlpass" "$mysqldb" | sed --expression='s/ AUTO_INCREMENT=[0-9]\+//' > "$schemadump" chown "root:$name-koha" "$schemadump" chmod g+r "$schemadump" else [ "$quiet" = "no" ] && echo "* DB to $dbdump" - mysqldump $dbflag --host="$mysqlhost" \ + mysqldump $dbflag --host="$mysqlhost" --single-transaction \ --user="$mysqluser" --password="$mysqlpass" "$mysqldb" | gzip > "$dbdump" chown "root:$name-koha" "$dbdump" -- 2.25.1