Backupper

Backupper is a tool to backup all your databases spread all over the world!

Installation

$ gem install backupper

Usage

$ backupper path/to/config.yml

Configuration file

A common YAML config file for backupper looks like this:

mailer:
from: support@email.com # Gmail account used to send report emailto: pioz@email.com # Send report email to this addresspassword: Pa$$w0rD # Gmail account passworddb1:
disabled: false # true to disable this backupdump: '/home/backup/db1'# path where to save the dump of the databaseextra_copy: '/mnt/backup-disk/backups/db1'# path where to save a extra copy of the dumpusername: user # server ssh usernamehost: '1.2.3.4'# server ssh ipport: 22# server ssh portpassword: Pa$$w0rD # server ssh passwordadapter: mysql # database to backup (supported are mysql or postgresql)database: db_name # database namedb_username: db_user # database usernamedb_password: db_Pa$$w0rD # database passworddump_options: '--single-transaction --quick'# dump command extra optionsdb2:
disabled: falsedump: '/home/backup/db2'extra_copy: '/mnt/backup-disk/backups/db2'username: userhost: '1.2.3.4'port: 22password: Pa$$w0rDadapter: postgresqldatabase: db_namedb_username: db_userdb_password: db_Pa$$w0rD

After done all backups a report email is sent to you using gmail smtp service (remember to permit less secure app here).

⚠️WARNING: the backupper configuration file contains many important passwords, so be careful to lock it and protect it with care!

Resources

• Blog post about Backupper (italian only).

Contributing

Bug reports and pull requests are welcome on GitHub at https://github.com/uqido/backupper.

License

The gem is available as open source under the terms of the MIT License.

About Uqido

Backupper is maintained and funded by Uqido. The names and logos for Uqido are trademarks of Uqido s.r.l.

The Uqido team.