aboutsummaryrefslogtreecommitdiff
path: root/README.txt
blob: cf90ed234b85ac354f3d9a689d22500634c577ba (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
DataBase Dump Sign Sync and Notify
----------------------------------


About
-----
Dump your database (wether if mysql (mariadb) or postgresql), obtain its 
sha256sum and sign with gpg (make files out of this for further verification),
sync everything to remote host (using rsync), notify yourself about to xmpp
recipient (jid or chatroom). Go get a beer and let the script do the job.


dbdssn is a shellscript to ease and automatize database backup processes
asociated to mysql (mariadb) and postgresql service enviroments with an 
approach on security.


Install
-------
Dowload the script into your localhost and execute as single user. 
For systemwide, copy the script into "/usr/local/bin/" as "dbdssn" (with not
extension) and give proper permissions. A cron job can also be configured.


Run
---
Run it with:

./dbdssn.sh [options] -f inputfile

./dbdssn.sh [-[sS]ron[h]] -f inputfile

For [options] and general usage, run "./dbdssn -h".

Inputfile examples is provided within repository.


Known issues 
(https://gitgud.io/ziggys/dbdssn/issues)

() pg_dump will fail when role password has special characters on it (like "/"
slash). To workaround this issue, urlcoded character can be parsed. I.E.:
#PASSWORD=1234/567; # MUST BE CHANGED TO
PASSWORD=1234%2F567

This issue is marked for future versions to convert special characters
into correct urlcoded format.


Unknown issues
Probably a lot