Hacker News new | ask | show | jobs
by gurraman 5347 days ago
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.

1 comments

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.