blob: 41435398286cf50471422e24fcfb3ff6c6be1eab (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
|
#!/bin/bash
#set -x
# get path to all needed tools
# /bin
echo=$(which echo)
grep=$(which grep)
mktemp=$(which mktemp)
pwd=$(which pwd)
rm=$(which rm)
# /usr/bin
cut=$(which cut)
dirname=$(which dirname)
expr=$(which expr)
head=$(which head)
mysql=$(which mysql)
mysqldump=$(which mysqldump)
nice=$(which nice)
ssh=$(which ssh)
tail=$(which tail)
# check if all needed tools are installed (only the ones not installed under /bin/)
alltoolsinstalled="yes"
test "$cut" = "" && echo "'cut' not installed or not found by 'which'" && alltoolsinstalled="no"
test "$dirname" = "" && echo "'dirname' not installed or not found by 'which'" && alltoolsinstalled="no"
test "$expr" = "" && echo "'expr' not installed or not found by 'which'" && alltoolsinstalled="no"
test "$head" = "" && echo "'head' not installed or not found by 'which'" && alltoolsinstalled="no"
test "$mysql" = "" && echo "'mysql' not installed or not found by 'which'" && alltoolsinstalled="no"
test "$mysqldump" = "" && echo "'mysqldump' not installed or not found by 'which'" && alltoolsinstalled="no"
test "$nice" = "" && echo "'nice' not installed or not found by 'which'" && alltoolsinstalled="no"
test "$ssh" = "" && echo "'ssh' not installed or not found by 'which'" && alltoolsinstalled="no"
test "$tail" = "" && echo "'tail' not installed or not found by 'which'" && alltoolsinstalled="no"
if [ "$alltoolsinstalled" = "no" ]
then
exit 1
fi
# main configuration
script_dir="$( cd "$( dirname "${BASH_SOURCE[0]}" )" && pwd )"
config_file="$script_dir/main.cfg"
# remote and local directories
db_dir="$script_dir/db"
usesamerepo="no"
backupdirsingle=db
# source a specified section from a specified config
function source_section {
config_name="$1"
section_name="$2"
section_start="^\[$section_name\]$"
section_end="^\[/$section_name\]$"
line_start=$($grep -n "$section_start" "$config_name" | $cut -d: -f1)
line_end=$($expr $($grep -n "$section_end" "$config_name" | $cut -d: -f1) - 1)
line_diff=$($expr $line_end - $line_start)
tmp_file=$($mktemp)
$head -n $line_end "$config_name" | $tail -n $line_diff > "$tmp_file"
source "$tmp_file"
$rm -f "$tmp_file"
}
# check if borg repo exists and create if not
function check_borg_repo {
repo="$1"
serverdir="$2"
usesamerepo="$3"
if [ "$usesamerepo" = "yes" ]
then
repo_path="$userserver:$backupdir/$serverdir"
else
repo_path="$userserver:$backupdir/$serverdir/$repo"
fi
#check if repo exists
$borg_local_path list --remote-path "$borg_remote_path" --no-files-cache "$repo_path" > /dev/null 2>&1
if [ $? -ne 0 ]
then
# create repo if not exists
$borg_local_path init --remote-path "$borg_remote_path" --encryption "$borg_encryption" "$repo_path"
fi
}
# backup single dir with borg
function backup_db {
repo="$1"
serverdir="$2"
usesamerepo="$3"
check_borg_repo "$repo" "$serverdir" "$usesamerepo"
# to get backup.ignore work with relative paths we need to change the directory
if [ "$usesamerepo" = "yes" ]
then
repo_path="$userserver:$backupdir/$serverdir::$repo-{now:$default_timestamp}"
else
repo_path="$userserver:$backupdir/$serverdir/$repo::{now:$default_timestamp}"
fi
ret=0
$borg_local_path create --remote-path "$borg_remote_path" --one-file-system --compression "$borg_compression" "$repo_path" .
ret=$?
if [ $ret -ne 0 ]
then
$echo "problem in borg create $repo"
fi
}
# general section from main config
source_section "$config_file" "general"
# change folder for temporary storage
cd "$db_dir"
# get all databases
databases=$($nice -n 19 $mysql -u root -N -e "show databases;" | $grep -v "^information_schema$" | $grep -v "^mysql$" | $grep -v "^performance_schema$")
# handle each database
for database in $databases
do
# dump database
$nice -n 19 $mysqldump -u root "$database" > "$database.sql"
backup_db "$database" "$backupdirsingle" "$usesamerepo"
# delete temporary file
$rm -f "$database.sql"
done # for database in $databases
|
