no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
| — | backup-manager [2012/01/16 18:09] (current) – created - external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ======= Backup Manager ====== | ||
| + | Backup Manager is a perl script designed to backup and optionally encrypt filesystems and databases. | ||
| + | |||
| + | === Checklist === | ||
| + | |||
| + | * ✔ root mysql user, with password in .my.cnf | ||
| + | * ✔ use --defaults-extra-file=/ | ||
| + | * ✔ don't use tarball-incremental, | ||
| + | |||
| + | === Configuration === | ||
| + | |||
| + | There is a template file installed at ''/ | ||
| + | |||
| + | The most common variables you would want to change are: | ||
| + | |||
| + | < | ||
| + | # Where to store the archives | ||
| + | export BM_REPOSITORY_ROOT="/ | ||
| + | |||
| + | # Number of days we have to keep an archive (Time To Live) | ||
| + | export BM_ARCHIVE_TTL=" | ||
| + | |||
| + | # The backup method to use. | ||
| + | # Available methods are: | ||
| + | # - tarball | ||
| + | # - tarball-incremental | ||
| + | # - mysql | ||
| + | # - pgsql | ||
| + | # - svn | ||
| + | # - pipe | ||
| + | # - none | ||
| + | # If you don't want to use any backup method (you don't want to | ||
| + | # build archives) then choose " | ||
| + | export BM_ARCHIVE_METHOD=" | ||
| + | |||
| + | </ | ||
| + | |||
| + | == Encryption == | ||
| + | |||
| + | < | ||
| + | # Uncomment the following line if you want to enable encryption | ||
| + | # export BM_ENCRYPTION_METHOD=" | ||
| + | |||
| + | # The encryption will be made using a GPG ID | ||
| + | # Examples: | ||
| + | # export BM_ENCRYPTION_RECIPIENT=" | ||
| + | # export BM_ENCRYPTION_RECIPIENT=" | ||
| + | # export BM_ENCRYPTION_RECIPIENT=" | ||
| + | </ | ||
| + | |||
| + | == Incremental Tarballs == | ||
| + | |||
| + | < | ||
| + | # Which frequency to use for the master tarball? | ||
| + | # possible values: weekly, monthly | ||
| + | export BM_TARBALLINC_MASTERDATETYPE=" | ||
| + | </ | ||
| + | |||
| + | === Gotchas === | ||
| + | |||
| + | == backup-manager and ~/.my.cnf == | ||
| + | |||
| + | backup-manager will use the defaults from '' | ||
| + | |||
| + | In that case, if you have something like username in the personal configuration, | ||
| + | |||
| + | I suppose technically it could be a MySQL bug, since -u< | ||
| + | |||
| + | Backup Manager also creates a temporary file at '' | ||
| + | |||
| + | Probably the simplest way to do backups, if running as root, is to just use the same credentials located in the user's config file. Another option is to create a new user to run the process of archival and storage, but that would require the user to have read permissions to other users' files. | ||
| + | |||
| + | == cron and mkconfig == | ||
| + | |||
| + | When running mkconfig with cron, vixie-cron ignores the ~/.my.cnf file for some reason. | ||
| + | |||
| + | == Blacklist == | ||
| + | |||
| + | Here's some files to exclude when backing up: | ||
| + | |||
| + | < | ||
