X-Git-Url: https://git.cyclocoop.org/?a=blobdiff_plain;f=local%2Fbackup%2Fmysql-snapshot;h=24a07f3a6e6f51f6fb4516b5fc2eb0bad3854a89;hb=d85c16565d00de9646c03944f855e4cc6be368eb;hp=5140ffcb45ae3e3cb5b4d70aa8c7ad771bc2ea49;hpb=a11ad78672a096632b15a660509d7dd5f7c5eae5;p=lhc%2Fateliers.git

diff --git a/local/backup/mysql-snapshot b/local/backup/mysql-snapshot
index 5140ffc..24a07f3 100755
--- a/local/backup/mysql-snapshot
+++ b/local/backup/mysql-snapshot
@@ -15,11 +15,17 @@ test ! $# = 0 || set -- :
 install -d -m 770 -o backup -g backup \
  ~backup/snapshot/mysql
 
-snapshot () {
-	local database="$1"; shift
-	test ! -e ~backup/snapshot/mysql/$database
-		# NOTE: soit une sauvegarde est déjà en cours,
-		#       soit une précédente a échoué.
+errno=0
+while IFS='' read -r database
+ do {
+	test "${database:+set}"
+	if test -e ~backup/snapshot/mysql/$database
+	 then
+		cat >&2 <<-EOF
+			ERROR: soit une sauvegarde est déjà en cours, soit une précédente a échoué.
+			EOF
+		false
+	 fi
 	can_hotcopy=yes
 	while IFS='	' read -r table engine
 	 do
@@ -29,10 +35,10 @@ snapshot () {
 		 esac
 	 done <<-EOF
 		$(mysql -u backup --batch --skip-column-names <<-EOF
-				SELECT table_name,engine
-					FROM information_schema.tables
-					WHERE table_schema = '$database';
-				EOF
+			SELECT table_name,engine
+				FROM information_schema.tables
+				WHERE table_schema = '$database';
+			EOF
 		 )
 		EOF
 	case $can_hotcopy in
@@ -56,17 +62,15 @@ snapshot () {
 	eval "$@"
 	rm -rf \
 	 ~backup/snapshot/mysql/"$database"
- }
-
-exit=0
-while IFS='	' read -r database
- do if ! snapshot "$database" "$@"
-	 then
-		exit=1
-		cat >&2 <<-EOF
-			ERROR: snapshot "$database" "$@"
-			EOF
+ } || {
+	errno=$?
+	cat >&2 <<-EOF
+		ERROR: $0 "$database" "$@"
+		EOF
+	if test "${database:+set}"
+	 then rm -rf ~backup/snapshot/mysql/"$database"
 	 fi
+ }
  done <<-EOF
 	$(mysql -u backup --batch --skip-column-names <<-EOF
 		SELECT schema_name
@@ -76,4 +80,4 @@ while IFS='	' read -r database
 		EOF
 	 )
 	EOF
-exit $exit
+exit $errno