Database backup utility
Project description
backups
Basic tool to backup mysql databases.
Installation
pip install --upgrade backups
Usage
$ backups --help
Backups mysql databases
Usage:
backups env
backups ls [--file FILE] [--verbose]
backups show JOB [--file FILE] [--verbose]
backups databases JOB [--file FILE] [--verbose]
backups run JOB [--file FILE] [--verbose] [--dryrun]
backups run JOB [DATABASE] [--file FILE] [--verbose] [--dryrun]
Commands:
env Show the current environment
ls Prints the backup job names
show Prints the configuration for a job
databases Lists all databases on a backup job server
run Runs the backup for a job
Options:
-f --file FILE The backups config file (default /etc/backups/backups.yaml)
-d --dryrun Just prints the commands but doesn't execute them
-v --verbose Adds verbosity
-h --help Prints this help
--version Prints the current version
Environment variables:
BACKUPS_FILE The backups file (default /etc/backups/backups.yaml)
BACKUPS_DUMPS_DIR The dumps directory (default /tmp/backups)
BACKUPS_MYSQLDUMP The mysqldump binary (default picked from $PATH)
BACKUPS_LOG_LEVEL Default INFO
BACKUPS_STDERR The stderr log file (default /tmp/backups.err)
Check https://github.com/ptdorf/backups#backups for more info
Setup
Create a backups.yaml
file with content similar to:
backups:
jobs:
acme:
connection:
type: mysql
host: acme.com
username: backups
password: password
options:
server: true # Dumps the entire server into a single file
# By default it will create a single dump file for each database found
# Uncomment to only backups specific databases (one on each file)
# databases:
# - main_db
# - other_db
compress:
- type: zip
pasword: secret
upload:
- type: s3
bucket: acme-backups
path: databases
notify:
- type: slack
webhook: https://hooks.slack.com/services/x/y/z
channel: "#backups"
Now run it with
backups run acme --file backups.yaml
You can use the BACKUPS_FILE
env var instead:
export BACKUPS_FILE=backups.yaml
backups run acme
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
backups-0.2.24.tar.gz
(9.3 kB
view hashes)
Built Distribution
Close
Hashes for backups-0.2.24-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 366cb7e4e8ea10bdf1ae17d7be9b10dad5bf929702b92a12e40ba18099ae7753 |
|
MD5 | a117c2cedf5b53908a93fa6c09bfd49a |
|
BLAKE2b-256 | 12dd962bd656ec36151154b37d9c1124106806bae288e1ae9992319ec717fac5 |