Révision 5163fcf2
Ajouté par Julien Enselme il y a plus de 10 ans
| bin/all-reset-permissions.sh | ||
|---|---|---|
| 25 | 25 |
|
| 26 | 26 |
####### log |
| 27 | 27 |
chmod -R 700 $dir_log |
| 28 |
|
|
| 29 |
####### private |
|
| 30 |
chmod -R 700 $dir_private |
|
| bin/d6-all-dump-full.sh | ||
|---|---|---|
| 1 | 1 |
#!/bin/sh |
| 2 | 2 |
|
| 3 | 3 |
. /users/guest/assos/bin/scripts-config.sh |
| 4 |
. /users/guest/assos/bin/scripts-utils.sh |
|
| 5 |
|
|
| 6 |
help="ARG: database password" |
|
| 7 |
|
|
| 8 |
check_arguments $# 1 "$help" |
|
| 4 | 9 |
|
| 5 | 10 |
current_date=`date "+%Y-%m-%d-%Hh%Mm%Ss"` |
| 6 | 11 |
|
| 7 | 12 |
# Dump D6 database with webassos user. |
| 8 |
mysqldump --single-transaction webassos -h myweb.serv.int -u webassos --password=HBVH2ljgyZCA0AP251DY > $d6_dir_full_backup/webassos/$current_date.webassos.sql |
|
| 13 |
mysqldump --single-transaction webassos -h myweb.serv.int -u webassos --password=$1 > $d6_dir_full_backup/webassos/$current_date.webassos.sql |
|
| bin/d6-dump-individual.sh | ||
|---|---|---|
| 1 | 1 |
#!/bin/sh |
| 2 | 2 |
|
| 3 | 3 |
. /users/guest/assos/bin/scripts-config.sh |
| 4 |
. /users/guest/assos/bin/scripts-utils.sh |
|
| 5 |
|
|
| 6 |
help="ARGS: # ARGS: auto or manual, site_prefix, database password" |
|
| 7 |
|
|
| 8 |
check_arguments $# 3 "$help" |
|
| 4 | 9 |
|
| 5 |
# ARGS: auto or manual, site_prefix |
|
| 6 | 10 |
# WARNING : backup are regularly flushed, put your backup in a safe place. |
| 7 | 11 |
|
| 8 | 12 |
cd $dir_individual_backup |
| ... | ... | |
| 11 | 15 |
tables='_%' |
| 12 | 16 |
liste="$1$tables" |
| 13 | 17 |
|
| 14 |
mysql -h myweb.serv.int -u webassos --password=HBVH2ljgyZCA0AP251DY -BNe "show tables like '"$liste"'" webassos | tr '\r\n' ' ' > liste_tables.temp
|
|
| 18 |
mysql -h myweb.serv.int -u webassos --password=$3 -BNe "show tables like '"$liste"'" webassos | tr '\r\n' ' ' > liste_tables.temp
|
|
| 15 | 19 |
|
| 16 | 20 |
#transformation de cette liste en une variable |
| 17 | 21 |
var=$(cat liste_tables.temp) |
| ... | ... | |
| 22 | 26 |
fichier="$1$suffixe" |
| 23 | 27 |
|
| 24 | 28 |
if [ $1 = 'auto' ] ; then |
| 25 |
mysqldump webassos -h myweb.serv.int -u webassos --password=HBVH2ljgyZCA0AP251DY $var > $d6_dir_individual_auto_backup/$fichier
|
|
| 29 |
mysqldump webassos -h myweb.serv.int -u webassos --password=$3 $var > $d6_dir_individual_auto_backup/$fichier
|
|
| 26 | 30 |
else |
| 27 |
mysqldump webassos -h myweb.serv.int -u webassos --password=HBVH2ljgyZCA0AP251DY $var > $d6_dir_individual_manual_backup/$fichier
|
|
| 31 |
mysqldump webassos -h myweb.serv.int -u webassos --password=$3 $var > $d6_dir_individual_manual_backup/$fichier
|
|
| 28 | 32 |
fi |
| 29 | 33 |
|
| 30 | 34 |
#suppression du fichier temporaire utilisé |
| bin/d7-all-dump-full.sh | ||
|---|---|---|
| 1 | 1 |
#!/bin/sh |
| 2 | 2 |
|
| 3 | 3 |
. /users/guest/assos/bin/scripts-config.sh |
| 4 |
. /users/guest/assos/bin/scripts-utils.sh |
|
| 5 |
|
|
| 6 |
help="ARG: database password" |
|
| 7 |
|
|
| 8 |
check_arguments $# 1 "$help" |
|
| 4 | 9 |
|
| 5 | 10 |
current_date=`date "+%Y-%m-%d-%Hh%Mm%Ss"` |
| 6 | 11 |
|
| 7 | 12 |
# Dump D7 databases at once. |
| 8 |
mysqldump -h $db_server -u $db_user -pNoNo82jJ --all-databases > $d7_dir_full_backup/myassos/$current_date.d7_full.sql |
|
| 13 |
mysqldump -h $db_server -u $db_user -p$1 --all-databases > $d7_dir_full_backup/myassos/$current_date.d7_full.sql |
|
| bin/scripts-config.sh | ||
|---|---|---|
| 10 | 10 |
dir_multi_assos='/users/guest/assos' |
| 11 | 11 |
dir_scripts="$dir_multi_assos/bin" |
| 12 | 12 |
dir_template="$dir_multi_assos/template" |
| 13 |
dir_private="$dir_multi_assos/private" |
|
| 13 | 14 |
|
| 14 | 15 |
###### Database |
| 15 | 16 |
db_server="myassos.serv.int" |
Formats disponibles : Unified diff
Rerendre le wiki public
Certains scripts comportaient des mots de passe de base de données. Ces mots de passe
ont été retirés des scripts pour que le wiki puisse redevenir public.