Every repository with this icon (
) is private.
Every repository with this icon (
) is public.
tree de0c3d1aa9b78c3ff8f9e95ed209b6e7ce971ca5
parent deb658f900be7c683266e93c89f8b4295ce36080
| name | age | message | |
|---|---|---|---|
 |
.gitignore | Wed Apr 08 16:06:26 -0700 2009 | |
| |
README.rst | Tue May 12 08:02:30 -0700 2009 | |
 |
dumpy/ | Tue May 12 08:08:48 -0700 2009 |
dumpy
Dumpy is a Python database backup script that uses configuration files to specify databases to backup and options. Backup scripts are classes which define a backup method.
Each BackupBase subclass returns a NamedTemporaryFile object. It's up to any post processors to use this object in any way (e.g. copy it to another location on the file system).
Post processors can be chained and all take the form:
MyPostProcessor().process(file)
If the post process doesn't alter the file passed in it should return it unchanged.
Example configuration file
The following is an idea of what the configuration file, located at ~/.dumpy.cfg might look like. This is very likely to change:
[database db1] type = mysql name = dbname1 user = db1 password = db1 postprocessing = TimestampRename, PrependDatabaseName, Bzip, FileSystemCopy, S3Copy [database db2] type = postgresql name = dbname2 user = db2 password = db2 postprocessing = TimestampRename, PrependDatabaseName, Bzip, FileSystemCopy, RotateFiles [mysqldump options] path = /opt/local/lib/mysql5/bin/mysqldump flags = -Q --opt --compact [pg_dump options] path = /opt/local/lib/postgresql83/bin/pg_dump [TimestampRename options] format = %%Y%%m%%d [Bzip options] path = /usr/bin/bzip2 [S3Copy options] access_key = access_key secret_key = secret_key bucket = bucket prefix = path/to/directory [FileSystemCopy options] directory = /path/to/directory/ [RotateFiles options] directory = /path/to/directory/ number = 5
Status
Beta. This is working and being used as a backup on a few systems but likely has bugs.
Motivation
I've written my last database dump and backup script that I want to. My hope is that this will be a general and feature rich backup script that's easily extendable and will work across multiple databases and backup schemes.
Installation
Download dumpy and put the dumpy module on your Python path. A way to quickly test dumpy might be:
$ git clone git://github.com/robhudson/dumpy.git $ cd dumpy $ export PYTHONPATH=$PYTHONPATH:`pwd`
Create a config file like the one above in your home directory named .dumpy.cfg.
To run the dumper.py command:
$ python /path/to/dumper.py
The dumper.py command takes the following options:
-h, --help Display help information -D DATABASE, --database=DATABASE Dump only the specified database with matching config name -v, --verbose Display logging output -a, --all-databases Dump all databases in the configuration file
Setting up a cron job
TODO
