README.MD 610 Bytes
Newer Older
Matthew Smith's avatar
Matthew Smith committed
1
2
3
# Sol1 db dump
Adds backup script and create cronjob

Matthew Smith's avatar
Matthew Smith committed
4
Only does mysql and pgsql at the moment.
Matthew Smith's avatar
Matthew Smith committed
5
6
7
8
9
10

## Usage
```
db_backup_crond:
  - name: "mysql"
  - name: "example"
Matthew Smith's avatar
Matthew Smith committed
11
    cron:
Matthew Smith's avatar
Matthew Smith committed
12
      command: "{{ db_backup_cron_default.command }} example -t mysql"
Matthew Smith's avatar
Matthew Smith committed
13
14
  - name: "example2"
    cron:
Matthew Smith's avatar
Matthew Smith committed
15
      command: "{{ db_backup_cron_default.command }} example2 -o '-Fc' -t 'pgsql'"
Matthew Smith's avatar
Matthew Smith committed
16
17
      minuite: 2
      hour: 3
Matthew Smith's avatar
Matthew Smith committed
18
19
```

Matthew Smith's avatar
Matthew Smith committed
20
21
Database name (-d) and Type (-t) are required fields, db_backup_cron_default.command is default script path + -d

Matthew Smith's avatar
Matthew Smith committed
22
Note: the cron defaults are sensible but not infalible, best to be explicit in setting them if unsure