Hacker News Reader

Hacker News

Comment by genieyclo | Hacker News Reader

Full thread

genieyclo

Have you all ever taken a look at Django-DBBackup?

http://pushingkarma.com/projects/django-dbbackup/

What is your opinion on it? Compared to South?

View on HN

There is no comparison to South. South is used for migrating table schema, not backing up.

I don't get it - what does django-dbbackup offer over 4 lines of bash:

    outputfile=/tmp/database_`date +%Y_%m_%d`.sql.gz
    pg_dump fashiondb -U fashionuser | gzip > $outputfile
    s3cmd --config ~/.s3cfg put $outputfile s3://mybucket
    rm $outputfile

Well, code to restore the database from a backup for one. It also seems to track form which server backups were created.

I haven't looked, but it might also, in the spirit of Django, be "database agnostic" and allow you to import data across DBMSs. You'd still need to keep some things like uploaded files in sync though.

Restoring is another 6 lines of bash:

    s3cmd --config ~/.s3cfg get s3://BUCKET/database_$1.sql.gz
    gunzip database_$1.sql.gz
    sudo -u postgres dropdb DBNAME
    sudo -u postgres createdb -O DBUSER DBNAME
    sudo -u postgres psql DBNAME < database_$1.sql
    rm database_$1.sql

But I suppose being database agnostic would be handy - it would make switching from mysql to postgres easier.

Reply on news.ycombinator.com