genieyclo on Yipit Django Blog: Sharing Everything We’re Learning

Comment on Yipit Django Blog: Sharing Everything We’re Learning

genieyclo 14y

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?

amccloud 14y

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

yummyfajitas 14y

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

gurraman 14y

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.

yummyfajitas 14y

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.

Comments