2 ms·
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 fashionuse
by yummyfajitas 15y ago
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 15y agoWell, 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 15y agoRestoring 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.