http://github.com/django-backup/django-backup

Backup, compress and restore database and media files. Transfer them via email or FTP and maintain a set number of dated versions on remote FTP server.

• project started by Dmitriy Kovalev (http://code.google.com/p/django-backup/ http://code.google.com/u/dmitriy.kovalev/)
• based off of backupdb command by msaelices (http://www.djangosnippets.org/snippets/823/)
• and also snippets from http://www.yashh.com/blog/2008/sep/05/django-database-backup-view/
• with minor modifications by Michael Huynh ([email protected]) http://github.com/mikexstudios/django-backup
• Major modifications in this fork by Andy Baker ([email protected] and Chen Zhe ([email protected])
• Lots more improvements including tests and packaging by Horst Gutmann (https://zerokspot.com/weblog/)

• Facility to backup media directories in addition to backing up SQL dump
• Transfer backups to remote FTP site
• cleanmedia and cleandb options allow you to only retain a set number of backups on the remote ftp site. Can specify via settings different values for days, weeks and years to retain (see below)
• 'manage.py restore' pulls down the latest backup from FTP and feeds it to mysql
• option to delete alllocal backups
• if using FTP you can opt not to retain local copy of backups
• Unfortunately Postgres support hasn't been kept up to date in this version. It shouldn't be that hard to replace.

--email
default=None
Sends email with attached dump file

--compress -c
default=False
Compress SQL dump file

--zipencrypt -z
default=False
Uses zip to package the backup and encrypts it with a password
provided in the BACKUP_PASSWORD environment variable.

--ftp -f
default=False
Store backup on remote FTP server

--no-database -d
default=False
Don't restore the database from the remote server
(useful if you just want the media)

--media -m
default=False
Backup media dirs as well as SQL dump

--rsync -r
default=False
Backup media dirs with rsync

--nolocal
default=False
Keep local copies of backup

--deletelocal
default=False
Delete all local backups

--cleandb
default=False
Clean up surplus database backups

--cleanmedia
default=False
Clean up surplus media backups

--cleanlocaldb
default=False
Clean up surplus local database backups

--cleanlocalmedia
default=False
Clean up surplus local media backups

--cleanremotedb
default=False
Clean up surplus remote database backups

--cleanremotemedia
default=False
Clean up surplus remote media backups

--cleanrsync
default=False
Clean up broken rsync backups

--cleanlocalrsync
default=False
Clean up local broken rsync backups

--cleanremotersync
default=False
Clean up remote broken rsync backups

When rsync flag is combined with ftp flag data will be backed up using rsync to a remote server. When rsync flag is used without the ftp flag data will be backed up to the local machine.

BACKUP_SQLDUMP_PATH = '/path/to/mysqldump' # mysqldump binary location
BACKUP_LOCAL_DIRECTORY = '/path/to/backups' # Where to store local backups

BACKUP_FTP_SERVER = 'example.com'
BACKUP_FTP_USERNAME = 'username'
BACKUP_FTP_PASSWORD = 'password'
BACKUP_FTP_DIRECTORY = '/path/to/backups/mysite' # If you store multiple backups on the same remote server ensure each one is in a different directory
RESTORE_FROM_FTP_DIRECTORY = '/path/to/backups/mysite' # Where does the restore

# How many db backups should we keep on remote FTP? i.e. 1 per day for the last 7 days plus 1 per week for the last 4 weeks etc.
BACKUP_DATABASE_COPIES = {
   'daily': 7,
   'weekly': 4,
   'monthly': 12,
}

# Same as above
BACKUP_MEDIA_COPIES = {
   'daily': 1,
   'weekly': 2,
   'monthly': 4,
}

Note that the settings which include FTP in their name will also be used for rsync.

A db-only backup

python manage.py backup --ftp

db plus rsync media backup

python manage.py backup --media --rsync --ftp

db plus SFTP media backup

python manage.py backup --media --ftp

Restore the most recent backup including media

python manage.py restore --media

db plus rsync media backup, validate remote rsync backups, clearn surplus media and db backs, and do not keep local copies of backups.

python manage.py backup --media --rsync --ftp --deletelocal --cleanremotedb --cleanremotemedia --cleanremotersync

or

call_command("backup", ftp=True, media=True, delete_local=True, clean_remote_db=True, clean_remote_media=True, clean_remote_rsync=True)