-
Notifications
You must be signed in to change notification settings - Fork 0
/
backup-mariadb.py
81 lines (78 loc) · 2.74 KB
/
backup-mariadb.py
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
import gzip
from os import getenv, remove
from datetime import datetime as dt
from subprocess import Popen, PIPE
from os.path import getmtime
from glob import glob
from traceback import print_exc
import json
from time import sleep
from requests import get
if getenv("TG_ENDPOINT", None) is None:
endpoint = "https://api.telegram.org/"
else:
endpoint = getenv("TG_ENDPOINT")
endpoint += f"bot{getenv('TG_TOKEN_BACKUP')}/"
timeout = int(getenv("TG_TIMEOUT", 10))
chat = getenv("CHAT_BACKUP")
date = dt.now().strftime("%Y_%m_%d_%H_%M")
file_name = 'backup_{custom}_{date}.gz'.format(custom=getenv("NAME"),
date=date)
database = getenv("MYSQL_DB", None)
if database is None or database.lower() == 'all':
database = "--all-databases"
program = ("/usr/bin/mysqldump --user={user} " +
"--password={pwd} -h {host} {database}").format(
user=getenv("MYSQL_USER"),
pwd=getenv("MYSQL_PASSWORD"),
host=getenv("MYSQL_HOST"),
database=database)
try:
p = Popen(program, shell=True, stdout=PIPE)
with gzip.open(file_name, "wb") as f:
f.writelines(p.stdout)
split = (f"/usr/bin/zip -r -s {getenv('MAX_SIZE_BACKUP')} " +
f"{file_name}.zip {file_name} " +
f"--password {getenv('BACKUP_PASSWORD')}")
p = Popen(split, shell=True)
p.wait()
files = []
content = []
for i, file in enumerate(sorted(glob(f"{file_name}.z*"), key=getmtime),
start=1):
content.append({"type": "document",
"media": f"attach://document{i}"})
files.append((f"document{i}", (file, open(file, "rb"))))
if i % 10 == 0:
print(content)
response = get(f"{endpoint}sendMediaGroup",
params={'chat_id': chat,
'disable_notification': True,
'media': json.dumps(content)},
files=files,
timeout=timeout)
print(response.status_code, response.text)
content = []
files = []
sleep(0.13)
if len(files) >= 0:
get(f"{endpoint}sendMediaGroup",
params={'chat_id': chat,
'media': json.dumps(content)},
files=files,
timeout=timeout)
text = "#{custom}\n#d{date}\n{file}".format(
custom=getenv("NAME"),
date=date,
file=f"{date}_{getenv('NAME')}",
)
get(f"{endpoint}sendMessage",
params={'chat_id': chat,
'text': text,
'parse_mode': 'HTML'})
except Exception:
print_exc()
remove(file_name)
for file in glob(f"{file_name}.z*"):
remove(file)
print(f"finish backup {file_name}")