X-Git-Url: http://git.cyclocoop.org/?p=lhc%2Fateliers.git;a=blobdiff_plain;f=local%2Fbackup%2Fmysql-snapshot;h=24a07f3a6e6f51f6fb4516b5fc2eb0bad3854a89;hp=56e5b1492d83fedbac5e120eb64b5bcba989228a;hb=344f65c397f046293ed2e5aa2b9dcd49337bdd71;hpb=4e0412adb2eafeb71122b2f41c12b4bf2d138ed7 diff --git a/local/backup/mysql-snapshot b/local/backup/mysql-snapshot index 56e5b14..24a07f3 100755 --- a/local/backup/mysql-snapshot +++ b/local/backup/mysql-snapshot @@ -15,22 +15,17 @@ test ! $# = 0 || set -- : install -d -m 770 -o backup -g backup \ ~backup/snapshot/mysql -trap_exit () { - errno=$? - test $errno = 0 || - cat >&2 <<-EOF - ERROR: $0 "$database" "$@" - EOF - #return $errno - } -trap trap_exit EXIT - +errno=0 while IFS='' read -r database - do + 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é. + 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 @@ -40,10 +35,10 @@ while IFS='' read -r database 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 @@ -67,6 +62,15 @@ while IFS='' read -r database eval "$@" rm -rf \ ~backup/snapshot/mysql/"$database" + } || { + 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,3 +80,4 @@ while IFS='' read -r database EOF ) EOF +exit $errno