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

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

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