From dd822c2317399a056d1ace905c0d1ef8c237391a 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 Content-Type: text/plain; charset=utf-8 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 Signed-off-by: Marcel de Rooy --- 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.20.1