X-Git-Url: http://git.cyclocoop.org/?p=lhc%2Fateliers.git;a=blobdiff_plain;f=local%2Fbackup%2Fmysql-snapshot;h=56e5b1492d83fedbac5e120eb64b5bcba989228a;hp=d77d2bf8bcc25415ffc0bba0ac1395a4c3aa270d;hb=9415f166b6f0c9d08c4c2c9fb6f023c2385d6d46;hpb=f470f64ed345b194308cd5d24e6d19218a349901

diff --git a/local/backup/mysql-snapshot b/local/backup/mysql-snapshot
index d77d2bf..56e5b14 100755
--- a/local/backup/mysql-snapshot
+++ b/local/backup/mysql-snapshot
@@ -15,20 +15,31 @@ 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" &&
+trap_exit () {
+	errno=$?
+	test $errno = 0 ||
+	cat >&2 <<-EOF
+		ERROR: $0 "$database" "$@"
+		EOF
+	#return $errno
+ }
+trap trap_exit EXIT
+
+while IFS='' read -r database
+ do
+	test "${database:+set}"
+	test ! -e ~backup/snapshot/mysql/$database
 		# NOTE: soit une sauvegarde est déjà en cours,
 		#       soit une précédente a échoué.
-	can_hotcopy=yes &&
+	can_hotcopy=yes
 	while IFS='	' read -r table engine
 	 do
 		case $engine in
 		 (MyISAM|ARCHIVE) :;;
 		 (*) can_hotcopy=no;;
 		 esac
-	 done <<-EOF &&
-		$(mysql -u backup --batch --skip-column-names <<-EOF || exit 1
+	 done <<-EOF
+		$(mysql -u backup --batch --skip-column-names <<-EOF
 				SELECT table_name,engine
 					FROM information_schema.tables
 					WHERE table_schema = '$database';
@@ -37,38 +48,27 @@ snapshot () {
 		EOF
 	case $can_hotcopy in
 	 (yes)
-		cd / &&
+		cd /
 		sudo -u root find ~mysql-data -mindepth 1 -maxdepth 1 -type d -exec \
-		 install -d -m 750 -o mysql -g backup {} + &&
-		cd - >/dev/null 2>&1 &&
-		test "${TRACE:+set}" || quiet=--quiet &&
+		 install -d -m 750 -o mysql -g backup {} +
+		cd - >/dev/null 2>&1
+		test "${TRACE:+set}" || quiet=--quiet
 		mysqlhotcopy --method=cp -u backup ${quiet:-} \
 		 "$database" ~backup/snapshot/mysql
 		;;
 	 (no)
 		install -d -m 770 -o backup -g backup \
-		 ~backup/snapshot/mysql/"$database" &&
+		 ~backup/snapshot/mysql/"$database"
 		mysqldump --opt --events -u backup ${TRACE:+--verbose} \
-		 --result-file ~backup/snapshot/mysql/"$database"/dump.sql \
+		 --result-file ~backup/snapshot/mysql/$database/dump.sql \
 		 "$database"
 		;;
-	 esac &&
-	eval "$@" &&
+	 esac
+	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
-	 fi
  done <<-EOF
-	$(mysql -u backup --batch --skip-column-names <<-EOF || exit 1
+	$(mysql -u backup --batch --skip-column-names <<-EOF
 		SELECT schema_name
 			FROM information_schema.schemata
 			WHERE schema_name NOT IN ('information_schema', 'performance_schema')
@@ -76,4 +76,3 @@ while IFS='	' read -r database
 		EOF
 	 )
 	EOF
-exit $exit