2 # SYNTAX: $database_pattern -- $snapshot_eval
3 # DESCRIPTION: crée un instantané pour chaque base de données MySQL $database donnée
4 # DESCRIPTION: dans ~backup/snapshot/mysql/"$database",
5 # DESCRIPTION: puis évalue $snapshot_eval,
6 # DESCRIPTION: puis efface l'instantané.
9 test "$(id -u)" = "$(id -u backup)"
11 database_pattern
=$1; shift
12 test ! "${1-}" = -- ||
shift
13 test ! $# = 0 ||
set -- :
15 install -d -m 770 -o backup
-g backup \
16 ~backup
/snapshot
/mysql
19 local database
="$1"; shift
20 test ! -e ~backup
/snapshot
/mysql
/$database
21 # NOTE: soit une sauvegarde est déjà en cours,
22 # soit une précédente a échoué.
24 while IFS
=' ' read -r table engine
31 $(mysql -u backup --batch --skip-column-names <<-EOF
32 SELECT table_name,engine
33 FROM information_schema.tables
34 WHERE table_schema = '$database';
41 sudo
-u root
find ~mysql-data
-mindepth 1 -maxdepth 1 -type d
-exec \
42 install -d -m 750 -o mysql
-g backup
{} +
44 test "${TRACE:+set}" || quiet
=--quiet
45 mysqlhotcopy
--method=cp -u backup
${quiet:-} \
46 "$database" ~backup
/snapshot
/mysql
49 install -d -m 770 -o backup
-g backup \
50 ~backup
/snapshot
/mysql
/"$database"
51 mysqldump
--opt --events -u backup
${TRACE:+--verbose} \
52 --result-file ~backup
/snapshot
/mysql
/$database/dump.sql \
58 ~backup
/snapshot
/mysql
/"$database"
62 while IFS
=' ' read -r database
63 do if ! snapshot
"$database" "$@"
67 ERROR: snapshot "$database" "$@"
71 $(mysql -u backup --batch --skip-column-names <<-EOF
73 FROM information_schema.schemata
74 WHERE schema_name NOT IN ('information_schema', 'performance_schema')
75 AND schema_name LIKE '$database_pattern';