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
22 ERROR: $0 "$database" "$@"
28 while IFS
='' read -r database
30 test "${database:+set}"
31 test ! -e ~backup
/snapshot
/mysql
/$database
32 # NOTE: soit une sauvegarde est déjà en cours,
33 # soit une précédente a échoué.
35 while IFS
=' ' read -r table engine
42 $(mysql -u backup --batch --skip-column-names <<-EOF
43 SELECT table_name,engine
44 FROM information_schema.tables
45 WHERE table_schema = '$database';
52 sudo
-u root
find ~mysql-data
-mindepth 1 -maxdepth 1 -type d
-exec \
53 install -d -m 750 -o mysql
-g backup
{} +
55 test "${TRACE:+set}" || quiet
=--quiet
56 mysqlhotcopy
--method=cp -u backup
${quiet:-} \
57 "$database" ~backup
/snapshot
/mysql
60 install -d -m 770 -o backup
-g backup \
61 ~backup
/snapshot
/mysql
/"$database"
62 mysqldump
--opt --events -u backup
${TRACE:+--verbose} \
63 --result-file ~backup
/snapshot
/mysql
/$database/dump.sql \
69 ~backup
/snapshot
/mysql
/"$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';