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
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
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
EOF
)
EOF
-exit $exit
+exit $errno